Use ALTER DATABASE RENAME FILE 'old_name' TO 'new_name';
Start the instance to mount state and rename all files you moved
including datafiles, online log files and tempfiles.
The old names you get from controfile with these queries:
select name from v$datafile;
select member from v$logfile;
select name from v$tempfile;
You also need to adjust pfile/spfile if the controlfiles moved.




Reply With Quote