----查看欲导出的user
select * from dba_users
SELECT * FROM SYSTEM.TEMP_STAT2
--建立导出表temp_stat2,进行复制和导出
EXEC dbms_stats.create_stat_table('SYSTEM','temp_stat2');
exec dbms_stats.export_schema_stats('SYSTEM','temp_stat2','SYSTEM');
expdp SYSTEM/manager directory=SYSTEM_DIR dumpfile=gather_status.dmp logfile=gather_status.log tables=temp_stat2
--导出时将目录设置
SELECT * FROM ALL_DIRECTORIES;
create directory SYSTEM_DIR as '/u01/uat/expdp';
Grant read,write on directory SYSTEM_DIR to system;
select * from dba_users
SELECT * FROM SYSTEM.TEMP_STAT2
--建立导出表temp_stat2,进行复制和导出
EXEC dbms_stats.create_stat_table('SYSTEM','temp_stat2');
exec dbms_stats.export_schema_stats('SYSTEM','temp_stat2','SYSTEM');
expdp SYSTEM/manager directory=SYSTEM_DIR dumpfile=gather_status.dmp logfile=gather_status.log tables=temp_stat2
--导出时将目录设置
SELECT * FROM ALL_DIRECTORIES;
create directory SYSTEM_DIR as '/u01/uat/expdp';
Grant read,write on directory SYSTEM_DIR to system;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21302630/viewspace-1729079/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21302630/viewspace-1729079/