2012-05-21

PLS-00201: identifier 'SYS.DBMS_EXPORT_EXTENSION' must be declared


Schema Import Fails With Error PLS-201 Identifier SYS.DBMS_EXPORT_EXTENSION Must Be Declared [ID 445135.]

Symptoms

Schema import fails with errors:
IMP-00058: ORACLE error 6550 encountered
ORA-06550: line 1, column 7:
PLS-00201: identifier 'SYS.DBMS_EXPORT_EXTENSION' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN SYS.DBMS_EXPORT_EXTENSION.SET_IMP_SKIP_INDEXES_OFF; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 8:
PLS-00201: identifier 'SYS.DBMS_EXPORT_EXTENSION' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN SYS.DBMS_EXPORT_EXTENSION.SET_IMP_SKIP_INDEXES_OFF; END;"

Cause

Import uses DBMS_EXPORT_EXTENSION package and you need to grant execute on DBMS_EXPORT_EXTENSION to the schema user being imported into.

Solution

The main issue here is lack of privileges. There are 2 possible solutions:

1. Grant execute on DBMS_EXPORT_EXTENSION to public.

Or:

2. Grant execute on DBMS_EXPORT_EXTENSION to the user/schema you are importing into (not the user who is running the import). For example, if you are importing into schema CDM_DB0 then grant execute to that user..

Niciun comentariu:

Trimiteţi un comentariu