批量生成修改路径的脚本.
select ‘alter database rename file ‘‘‘ || name ||‘‘‘‘ || ‘ to ‘‘‘|| substr(name,0,instr(name,‘/‘,-1) -1)|| ‘_ST‘ || substr(name,instr(name,‘/‘,-1)) ||‘‘‘;‘
from v$datafile;
select ‘alter database rename file ‘‘‘ || name ||‘‘‘‘ || ‘ to ‘‘‘|| substr(name,0,instr(name,‘/‘,-1) -1)|| ‘_ST‘ || substr(name,instr(name,‘/‘,-1)) ||‘‘‘;‘
from v$tempfile;
select ‘alter database rename file ‘‘‘ || member ||‘‘‘‘ || ‘ to ‘‘‘|| substr(member,0,instr(member,‘/‘,-1) -1)|| ‘_ST‘ || substr(member,instr(member,‘/‘,-1)) ||‘‘‘;‘
from v$logfile;
oracle 批量改temp/data/redo file的路径
原文：http://www.cnblogs.com/heric/p/6483324.html