I'm having some problems moving DATAFILE from one location to another due to the shortage of storage space. I've managed to change the path file of control file via command(linux). Now I would like to change the path file of the datafile and logs to another since I've already manual moved the folder of the database.

 SQL> startup;
 ORACLE instance started.

 Total System Global Area 6710886400 bytes
 Fixed Size                  2939560 bytes
 Variable Size            3506439512 bytes
 Database Buffers         3187671040 bytes
 Redo Buffers               13836288 bytes
 Database mounted.
 ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
 ORA-01110: data file 1: '/app/oracle/oradata/ENOVIA/system01.dbf'

Apparently, the data files are moved to another location, wheras the path of the files has yet to be changed. How can I check for the current location of Database in SQL and which command is needed to be used to alter the path file? *The new location is home/oradata/ENOVIA .

  • Seeing as you don't actually know Oracle, the easiest thing to do is to symbolic link the old directory to the new one. That way you don't have to touch Oracle – Philᵀᴹ Jul 3 '18 at 11:07

Look at the alter database rename file command; this should update the location of the file in the control file.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.