Friday, December 14, 2007

ORA-00600 [qmxtrScalarIsRewritable:dft] during expdp

Hit below two errors during running exp & expdp.

After increase shared pool size , the program gone.

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user DBAM2
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user DBAM2
About to export DBAM2's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [qmxtrScalarIsRewritable:dft], [], [], [], [], [], [], []
EXP-00000: Export terminated unsuccessfully



> cat expdp_DBAM2.log
;;;
Export: Release 10.2.0.2.0 - 64bit Production on Friday, 14 December, 2007 9:05: 54

Copyright (c) 2003, 2005, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Starting "LIQY"."EXPDP_DBAM2": parfile=exp_DBAM2.par
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 3.861 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
ORA-31693: Table data object "DBAM2"."M1_TM_COLLECTION_HISTORY" failed to load/u nload and is being skipped due to error:
ORA-04031: unable to allocate 48 bytes of shared memory ("shared pool","BEGIN S YS.KUPF$FILE.UPD_TDX...","parameters","kglpda")
. . exported "DBAM2"."M1_TM_FIN_TRANS_TRACKING" 888.1 MB 11968728 rows
. . exported "DBAM2"."M1_TM_LDL_SCT_DC_PAYMENT_UPD" 258.3 MB 2119285 rows
. . exported "DBAM2"."M1_TM_CONTACT_HISTORY_DONE" 715.0 MB 8097902 rows
. . exported "DBAM2"."M1_TM_SMS_ACTION" 100.0 MB 488877 rows
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.
Job "LIQY"."EXPDP_DBAM2" stopped due to fatal error at 09:08:59
ORA-39014: One or more workers have prematurely exited.