ITPub博客

首页 > 数据库 > Oracle > ORA-600 [kpotcgah-9]

ORA-600 [kpotcgah-9]

原创 Oracle 作者:pingshx 时间:2009-12-21 16:53:45 0 删除 编辑

环境:
DB: 10.2.0.4
OS: SunOS HOSTNAME 5.10 Generic_120011-14 sun4u sparc SUNW,Sun-Fire-V490

碰到这个错误的情形:用expdp导一张表,除了参数directory,dumpfile,logfile,tables之外,加上了parallel=4参数,得到的具体错误如下:

[@more@]

Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
ORA-31693: Table data object "BASELDWH"."AUX_FACT_EREC_DETL" 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 code, arguments: [], [], [], [], [], [], [], []
], [], [], [], [], []
ORA-06512: at "SYS.ORACLE_DATAPUMP", line 19
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

一开始怀疑要导的这个表出现了什么问题,用传统的exp去导,没问题,这样推断,表本身不存问题,那很有可能是expdp出现了问题,metalink文档781326.1提到,这是一个没有公布的bug:
Bug 6155249 was closed as not reproducible. The underlying problem seems to be a shortage in Shared Pool, even if no ORA-4031 occurs.

Solution
1) Increasing SGA_TARGET has a good chance to solve the problem.
2) Using noparallel export can avoid the problem.

把parallel参数去了,expdp就没问题了。

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

上一篇: ORA-00600 [kqludp2]
请登录后发表评论 登录
全部评论
  • 博文量
    44
  • 访问量
    156408