EXPDP IMPDP where l.table_name like'SYS_IMPORT_FULL_01%' and 問題

select l.owner,
l.table_name,
l.segment_name,
s.bytes/1024/1024
from dba_lobs l, dba_segments s
where l.table_name like'SYS_IMPORT_FULL_01%' and
l.table_name =s.segment_name;

select owner,table_name,segment_name from dba_lobs

 

 
在進行expdp備份時，會產生相應的表格(SYS_EXPORT_FULL_n)，

正常情況下，在備份結束JOB會自動清除table。

如果不能正常清除，可手動直接drop這樣的table。

長時間累計過多，不但占用system表空間，也會影響dp無法備份。

後續，有這樣的情況，大家可照此作業。

kupprdp: master process DM00 started with pid=36, OS id=2029
         to execute - SYS.KUPM$MCP.MAIN('SYS_EXPORT_FULL_72', 'SYSTEM', 'KUPC$C_1_20110126010009', 'KUPC$S_1_20110126010
009', 0);
kupprdp: worker process DW01 started with worker id=1, pid=39, OS id=2303
         to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_72', 'SYSTEM');
Wed Jan 26 01:01:14 2011
Thread 1 advanced to log sequence 125785
  Current log# 5 seq# 125785 mem# 0: /u02/oradata/hasfcdb1/redo05a.log
kupprdp: worker process DW02 started with worker id=2, pid=31, OS id=2979
         to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_72', 'SYSTEM');
kupprdp: worker process DW03 started with worker id=3, pid=46, OS id=2981
         to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_72', 'SYSTEM');
kupprdp: worker process DW04 started with worker id=4, pid=47, OS id=2983
         to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_72', 'SYSTEM');

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11366721/viewspace-688345/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11366721/viewspace-688345/