복구작업 중 datafile rename 작업 편하게 하기

 

1 2 3 4 5 6 7

select 'alter database rename file '''|| name || ''' to ''' || '&path' || substr(name, instr(name, '/', -1)+1) || ''';' from v$datafile; select 'alter database rename file '''|| member || ''' to ''' || '&path' || substr(member, instr(member, '/', -1)+1) || ''';' from v$logfile;