ORA-600 [kpotcgah-9]

环境：
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博客 ” ，链接：http://blog.itpub.net/45188/viewspace-1029864/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/45188/viewspace-1029864/