EXPDP: PLS-201 identifier 'SYS.DBMS_CUBE_EXP' must be declared
(Doc ID 1328829.1)
Last updated on JULY 11, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Oracle RDBMS version 11.2.0.2. When attempting DataPump export (expdp) the following errors occur:
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS []
ORA-31642: the following SQL statement fails:
BEGIN "SYS"."DBMS_CUBE_EXP".SCHEMA_CALLOUT(:1,0,1,'11.02.00.00.00'); END;
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 1245
ORA-06550: line 1, column 8:
PLS-00201: identifier 'SYS.DBMS_CUBE_EXP' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 8353
----- PL/SQL Call Stack -----
object line object
handle number name
0x139b48e78 19208 package body SYS.KUPW$WORKER
0x139b48e78 8385 package body SYS.KUPW$WORKER
0x139b48e78 12748 package body SYS.KUPW$WORKER
0x139b48e78 2546 package body SYS.KUPW$WORKER
0x139b48e78 9054 package body SYS.KUPW$WORKER
0x139b48e78 1688 package body SYS.KUPW$WORKER
0x13da077b0 2 anonymous block
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS []
ORA-31642: the following SQL statement fails:
BEGIN "SYS"."DBMS_CUBE_EXP".SCHEMA_CALLOUT(:1,0,1,'11.02.00.00.00'); END;
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 1245
ORA-06550: line 1, column 8:
PLS-00201: identifier 'SYS.DBMS_CUBE_EXP' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 8353
----- PL/SQL Call Stack -----
object line object
handle number name
0x137cadbc8 19208 package body SYS.KUPW$WORKER
0x137cadbc8 8385 package body SYS.KUPW$WORKER
0x137cadbc8 12748 package body SYS.KUPW$WORKER
0x137cadbc8 2546 package body SYS.KUPW$WORKER
0x137cadbc8 9054 package body SYS.KUPW$WORKER
0x137cadbc8 1688 package body SYS.KUPW$WORKER
0x1574b1700 2 anonymous block
Job "SYS"."SYS_EXPORT_SCHEMA_06" stopped due to fatal error at 16:33:33
ORA-31642: the following SQL statement fails:
BEGIN "SYS"."DBMS_CUBE_EXP".SCHEMA_CALLOUT(:1,0,1,'11.02.00.00.00'); END;
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 1245
ORA-06550: line 1, column 8:
PLS-00201: identifier 'SYS.DBMS_CUBE_EXP' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 8353
----- PL/SQL Call Stack -----
object line object
handle number name
0x139b48e78 19208 package body SYS.KUPW$WORKER
0x139b48e78 8385 package body SYS.KUPW$WORKER
0x139b48e78 12748 package body SYS.KUPW$WORKER
0x139b48e78 2546 package body SYS.KUPW$WORKER
0x139b48e78 9054 package body SYS.KUPW$WORKER
0x139b48e78 1688 package body SYS.KUPW$WORKER
0x13da077b0 2 anonymous block
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS []
ORA-31642: the following SQL statement fails:
BEGIN "SYS"."DBMS_CUBE_EXP".SCHEMA_CALLOUT(:1,0,1,'11.02.00.00.00'); END;
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 1245
ORA-06550: line 1, column 8:
PLS-00201: identifier 'SYS.DBMS_CUBE_EXP' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 8353
----- PL/SQL Call Stack -----
object line object
handle number name
0x137cadbc8 19208 package body SYS.KUPW$WORKER
0x137cadbc8 8385 package body SYS.KUPW$WORKER
0x137cadbc8 12748 package body SYS.KUPW$WORKER
0x137cadbc8 2546 package body SYS.KUPW$WORKER
0x137cadbc8 9054 package body SYS.KUPW$WORKER
0x137cadbc8 1688 package body SYS.KUPW$WORKER
0x1574b1700 2 anonymous block
Job "SYS"."SYS_EXPORT_SCHEMA_06" stopped due to fatal error at 16:33:33
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |