oracle冷被脚本

select 'ho copy'|| name || 'c:/oracle/' from v$controlfile

union all

select 'ho copy '|| name ||' c:/oracle/' from v$datafile;

union all

selelct 'ho  copy '|| name || ' c:/oracle/' from  v$tempfile

union all

select 'ho copy '|| member ||'  c:/oracle/ ' from v$logfile

/

create pfile='c:/oracle/' from spfile;

ho copy %oracle_home/database/PWDorcl.ora%

保存运行，可以得到录制脚本...........................