select 'alter database rename file "'|| name || '" to "D:\beifen\oradata"' from v$datafile;
crosscheck archivelog all;
delete noprompt archivelog all;
alter system set db_recovery_file_dest='' scope=spfile;
alter system reset db_recovery_file_dest_size scope=spfile sid='*';
grant execute on sys.dbms_defer_import_internal to hr;
grant execute on sys.dbms_export_extension to hr;
grant exp_full_database to hr;
crosscheck archivelog all;
delete noprompt archivelog all;
alter system set db_recovery_file_dest='' scope=spfile;
alter system reset db_recovery_file_dest_size scope=spfile sid='*';
grant execute on sys.dbms_defer_import_internal to hr;
grant execute on sys.dbms_export_extension to hr;
grant exp_full_database to hr;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30606744/viewspace-2101738/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30606744/viewspace-2101738/