rename file/rename tempfile

Oracle批量重命名数据文件、重命令临时文件

Linux:

---修改日志文件
set linesize 200 pagesize 200
 select 'alter database rename file '|| ''''||  member ||''''||' to ''+DATADG/CRMSC/ONLINELOG/'||substr(member, instr(member, '/', -1) + 1) ||
 ''';' from v$logfile;

---临时文件路径
select 'alter database rename file '|| ''''||  name ||''''||' to '||''''||replace(name,'+DATADG/CGCRMSCADG','+DATADG/CGCRMSC')||''''||';'  from v$tempfile;


set linesize 200 pagesize 200
 select 'alter database rename file '|| ''''||  member ||''''||' to ''/data/soa/'||substr(member, instr(member, '/', -1) + 1) ||
 ''';' from v$logfile;


 select 'alter database rename file '|| ''''||  name ||''''||' to ''/systdb/data/'||substr(name,instr(name, '/', -1) + 1) || ''';'
 from v$tempfile;

    select 'alter database rename file '||''''||name||''''||' to ''/data/soa/soadev/'||substr(name, instr(name, '/', -1) + 1)||''';' from
 v$dbfile;
 
 

 Windows:
 
---批量修改日志文件
set linesize 200 pagesize 200
 select 'alter database rename file '|| ''''||  member ||''''||' to ''D:\data\jphis\'||substr(member, instr(member, '\', -1) + 1) ||
 ''';' from v$logfile;


---批量修改临时文件路径
select 'alter database rename file '|| ''''||  name ||''''||' to '||''''||replace(name,'C:\APP\ADMINISTRATOR\ORADATA','D:\data')||''''||';'  from v$tempfile;


select 'alter database rename file '|| ''''||  name ||''''||' to ''D:\data\jphis\'||substr(name,instr(name, '\', -1) + 1) || ''';'
 from v$tempfile;


---批量修改数据文件路径
select 'alter database rename file '||''''||name||''''||' to ''D:\data\jphis\'||substr(name, instr(name, '\', -1) + 1)||''';' from
 v$dbfile;