DataPump Import (IMPDP) Receives The Errors ORA-39083 PLS-201 identifier DBMS_CUBE_EXP.SCHEMA_INFO_IMP_BEG (Doc ID 789549.1)

Last updated on MAY 03, 2013

Applies to:

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

Symptoms

This issue is faced in 11g onwards. This situation involves 2 databases. One database with OLAP schema (OLAPSYS) and another database without OLAP schema.

When you take an export from the database which has OLAP schema and import into a database without OLAP schema, the following error messages are displayed:

ORA-39083: Object type PROCACT_SCHEMA failed to create with error: 
ORA-06550: line 2, column 1: 
PLS-00201: identifier 'DBMS_CUBE_EXP.SCHEMA_INFO_IMP_BEG' must be declared 
ORA-06550: line 2, column 1: 
PL/SQL: Statement ignored 
ORA-06550: line 3, column 1: 
PLS-00201: identifier 'DBMS_CUBE_EXP.SCHEMA_INFO_IMP_LOOP' must be declared 
ORA-06550: line 3, column 1: 
PL/SQL: Statement ignored 
ORA-06550: line 7, column 1: 
PLS-00201: identifier 'DBMS_CUBE_EXP.SCHEMA_INFO_IMP_END' must be declared 
ORA-06550: line 7, c 
Processing object type SCHEMA_EXPORT/TABLE/TABLE 
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA 
. . imported "TEST"."DEPT" 5.937 KB 4  rows 
. . imported "TEST"."EMP" 8.570 KB 14  rows 
. . imported "TEST"."SALGRADE" 5.867 KB 5  rows 
. . imported "TEST"."BONUS" 0 KB 0  rows 
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX 
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT 
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS 
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT 
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS 
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA 
ORA-39083: Object type PROCACT_SCHEMA failed to create with error: 
ORA-06550: line 2, column 1: 
PLS-00201: identifier 'DBMS_CUBE_EXP.SCHEMA_INFO_IMP_BEG' must be declared 
ORA-06550: line 2, column 1: 
PL/SQL: Statement ignored 
ORA-06550: line 3, column 1: 
PLS-00201: identifier 'DBMS_CUBE_EXP.SCHEMA_INFO_IMP_LOOP' must be declared 
ORA-06550: line 3, column 1: 
PL/SQL: Statement ignored 
ORA-06550: line 7, column 1: 
PLS-00201: identifier 'DBMS_CUBE_EXP.SCHEMA_INFO_IMP_END' must be declared 
ORA-06550: line 7, c 
Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 3 error(s) at 04:22:32

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms