匯出gather_status分析--用於測試壓力等

----檢視欲匯出的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;