My Oracle Support Banner

DataPump Export Utility Fails With Errors ORA-39125 ORA-31642 PLS-201 on Package SYS.DBMS_CDC_EXPDP (Doc ID 825680.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.
***Checked for relevance on 15-Apr-2013***


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 - 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 - 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...
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:
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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.