Technical Notes

We're all on the same page!

Showing posts with label db file. Show all posts
Showing posts with label db file. Show all posts
Tuesday, 31 January 2017

How to remove datafile carefully?

›
find datafile path; SQL>  select file_name from dba_data_files; before run rm; $ cd /oradata $ lsof * $ rm -f alper_data_01.dbf
Thursday, 23 April 2015

How to transfer database file in Windows?

›
To do that please follow the instructions; Tablespace: ALPER_DATA Database file: data_01.dbf DB file path: C:\Databasefiles New databa...
Sunday, 26 October 2014

How to define a tablespace in Windows?

›
Please execute the commands as "sys"; To define the tablespace: SQL>  CREATE TABLESPACE ALPER_DATA  DATAFILE 'C:\table...
›
Home
View web version
Powered by Blogger.