EXPDP的parallel引數

kuqlan發表於2011-11-29

同一臺伺服器(OS:Linux 2.6.9-78.ELlargesmp,DB:10.2.0.1.0 - 64bit Production),匯出不同的使用者,一個沒有報錯,另一報如下錯誤:

ORA-31693: Table data object "GDGDZC"."SYS_EXPORT_SCHEMA_01" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-00942: table or view does not exist

而匯出指令碼核心語句如下:

expdp gdgdzc/gdgdzc dumpfile=dump_dir:gdgdzc.$FILE_DATE.dmp logfile=dump_dir:gdgdzc.log

[@more@]

網上查詢發現expdp也存在bug,引數parallel 的設定來避免這個bug,以上語句如下修改後匯出過程報錯資訊訊息了:

expdp gdgdzc/gdgdzc dumpfile=dump_dir:gdgdzc.$FILE_DATE.dmp parallel=1 logfile=dump_dir:gdgdzc.log

執行結果的部分內容如下:

.....

. . exported "GDGDZC"."VTZVFH4C7Z29Q0U2KQ9I2UN18CLS" 0 KB 0 rows
. . exported "GDGDZC"."VTZVFH4C7Z2CTTOF0HKJ5KU9EKIL" 0 KB 0 rows
Master table "GDGDZC"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for GDGDZC.SYS_EXPORT_SCHEMA_01 is:
/oraback/gdgdzc.1129.dmp
Job "GDGDZC"."SYS_EXPORT_SCHEMA_01" successfully completed at 18:44:19

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/18841027/viewspace-1056609/,如需轉載,請註明出處,否則將追究法律責任。

相關文章