set linesize 200 pagesize 300
spool copy.sh
select 'cp ' || name || ' ' || &2 || ' &' from v$datafile;
select 'cp ' || name || ' ' || &2 || ' &' from v$tempfile;
select 'cp ' || member || ' ' || &2 || ' &' from v$logfile;
spool off
spool copy.sh
select 'cp ' || name || ' ' || &2 || ' &' from v$datafile;
select 'cp ' || name || ' ' || &2 || ' &' from v$tempfile;
select 'cp ' || member || ' ' || &2 || ' &' from v$logfile;
spool off
shutdown immediate
./copy.sh
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22578826/viewspace-745552/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
