-- If doing on Source Server -- ::12c-->sqlplus "/as sysdba" set head off pages 0 feed off echo off verify off set lines 200 spool rename_datafiles.lst select 'set newname for datafile ' || file_id || ' to ''/u01/oradata/' || substr(file_name,instr(file_name,'/',-1)+1) || ''';' from dba_data_files ; spool off exit;
-- If doing on Target Server -- [oracle@testorcl ~]$ sqlplus "/as sysdba" set head off pages 0 feed off echo off verify off set lines 200 spool rename_datafiles.lst select 'set newname for datafile ' || file# || ' to ''/u01/oradata/' || substr(name,instr(name,'/',-1)+1) || ''';' from v$datafile ; spool off exit;