복구작업 중 datafile rename 작업 편하게 하기
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;
최신 댓글