Sample Header Ad - 728x90

Moving DataFile to Another Location ORACLE

1 vote
2 answers
2251 views
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 have already been moved to another location, whereas 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.
Asked by user154546 (19 rep)
Jul 3, 2018, 02:31 AM
Last activity: Feb 4, 2022, 09:00 PM