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 .