ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-31693

ORA-31693

原创 Linux操作系统 作者:g644516804 时间:2012-03-01 17:57:26 0 删除 编辑

今天导出两张大表,出现了如下错误

ORA-31693

$expdp  smp/******** directory=dumpdir dumpfile=wip_keypa1.dmp,wip_keypa2.dmp,wip_keypa3.dmp tables=wip_runcard,kp_keypart_flex logfile=expdp.log parallel=4

 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Starting "SMP"."SYS_EXPORT_TABLE_02":  smp/******** directory=dumpdir dumpfile=wip_keypa1.dmp,wip_keypa2.dmp,wip_keypa3.dmp tables=wip_runcard,kp_keypart_flex logfile=expdp.log parallel=4

Estimate in progress using BLOCKS method...

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 38.25 GB

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

ORA-31693: Table data object "SMP"."WIP_RUNCARD" failed to load/unload and is being skipped due to error:

ORA-29913: error in executing ODCIEXTTABLEOPEN callout

ORA-39077: unable to subscribe agent ORA-39077: unable to subscribe agent KUPC$A_1_20120301

ORA-31693: Table data object "SMP"."KP_KEYPART_FLEX" failed to load/unload and is being skipped due to error:

ORA-29913: error in executing ODCIEXTTABLEOPEN callout

ORA-00600: internal error code, arguments: [kpotcgah-9], [0], [ORA-00600: internal error co

Master table "SMP"."SYS_EXPORT_TABLE_02" successfully loaded/unloaded

******************************************************************************

Dump file set for SMP.SYS_EXPORT_TABLE_02 is:

  /ora103/oradata/wip_keypa1.dmp

  /ora103/oradata/wip_keypa2.dmp

  /ora103/oradata/wip_keypa3.dmp

Job "SMP"."SYS_EXPORT_TABLE_02" completed with 2 error(s) at 17:05:48

 

查看MOS Datapump Export fails with ORA-31693 ORA-600 [Kpotcgah-9] [ID 781326.1]

When Run In Parallel, Expdp Fails With Ora-31693 [ID 739138.1]

最后去除parallel参数直接导出

$expdp smp/******** directory=dumpdir dumpfile=wip_keypa.dmp tables=wip_runcard,kp_keypart_flex logfile=expdp.log

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

请登录后发表评论 登录
全部评论

注册时间:2011-03-04

  • 博文量
    104
  • 访问量
    237081