有网友提问在使用expdp时出现了ORA-39125、ORA-31642错误,具体错误信息如下:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Starting "EXPALL"."SYS_EXPORT_FULL_04": expall/******** directory=expdp_dir full=y dumpfile=exp_tposdb_full.dmp logfile=exp_tposdb_ full.log Estimate in progress using BLOCKS method... Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA ORA-39125: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS while calling DBMS_METADATA.FETCH_XML_CLOB [] ORA-31642: the following SQL statement fails: BEGIN "SYS"."DBMS_CDC_EXPDP".SCHEMA_CALLOUT(:1,0,1,'10.02.00.04.00'); END; ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86 ORA-06512: at "SYS.DBMS_METADATA", line 907 ORA-00942: table or view does not exist ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPW$WORKER", line 6307 ----- PL/SQL Call Stack ----- object line object handle number name 0xa19cbae8 15032 package body SYS.KUPW$WORKER 0xa19cbae8 6372 package body SYS.KUPW$WORKER 0xa19cbae8 9206 package body SYS.KUPW$WORKER 0xa19cbae8 1936 package body SYS.KUPW$WORKER 0xa19cbae8 6944 package body SYS.KUPW$WORKER 0xa19cbae8 1314 package body SYS.KUPW$WORKER 0xa15c0d34 2 anonymous block Job "EXPALL"."SYS_EXPORT_FULL_04" stopped due to fatal error at 14:06:05针对该错误可以参考Mos Note <DataPump Export Utility Fails With Errors ORA-39125 ORA-31642 PLS-201 on Package SYS.DBMS_CDC_EXPDP [ID 825680.1]>和<Export/Import DataPump: The Minimum Requirements to Use Export DataPump and Import DataPump (System Privileges) [ID 351598.1]>, 现引用如下文:
DataPump Export Utility Fails With Errors ORA-39125 ORA-31642 PLS-201 on Package SYS.DBMS_CDC_EXPDP Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 - Release: 10.2 to 10.2 Information in this document applies to any platform. Symptoms You try to export a schema from database using DataPump export utility. This ends with errors: #> expdp system/password directory=dpu dumpfile=test.dmp schemas=test Export: Release 10.2.0.4.0 - 64bit Production on Friday, 15 May, 2009 8:49:29 Copyright (c) 2003, 2007, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bitProduction With the Partitioning, Data Mining and Real Application Testing options FLASHBACK automatically enabled to preserve database integrity. Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** directory=dpu dumpfile=test.dmp schemas=test Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA ORA-39125: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS while calling DBMS_METADATA.FETCH_XML_CLOB [] ORA-31642: the following SQL statement fails: BEGIN "SYS"."DBMS_CDC_EXPDP".SCHEMA_CALLOUT(:1,0,1,'10.02.00.04.00'); END; ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86 ORA-06512: at "SYS.DBMS_METADATA", line 907 ORA-06550: line 1, column 7: PLS-00201: identifier 'SYS.DBMS_CDC_EXPDP' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPW$WORKER", line 6307 ----- PL/SQL Call Stack ----- object line object handle number name 0x7e8998d8 15032 package body SYS.KUPW$WORKER 0x7e8998d8 6372 package body SYS.KUPW$WORKER 0x7e8998d8 9206 package body SYS.KUPW$WORKER 0x7e8998d8 1936 package body SYS.KUPW$WORKER 0x7e8998d8 6944 package body SYS.KUPW$WORKER 0x7e8998d8 1314 package body SYS.KUPW$WORKER 0x76337f10 2 anonymous block Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 08:50:02 Cause These errors are raised, when either the EXECUTE privilege on package SYS.DBMS_CDC_EXPDP was revoked, or, when the package package SYS.DBMS_CDC_EXPDP was accidentally dropped from data dictionary. Verify this with: connect / as sysdba select grantee, privilege from
本文转自maclean_007 51CTO博客,原文链接:http://blog.51cto.com/maclean/1278092