IMP-3 ORA-6550 PLS-201 SYS.DBMS_DEFER_IMPORT_INTERNAL Raised When Connecting With An OS Authenticated User
Last updated on MARCH 13, 2013
Applies to:
Oracle Database - Enterprise Edition - Version 7.3.3.0 and laterInformation in this document applies to any platform.
***Checked for relevance on 13-Mar-2013***
Symptoms
Import FULL fails with the following error stack:
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('BII_EUPC.WARSM02"
"3','IBMPC/WIN_NT-8.1.0'); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 9:
PLS-00201: identifier 'SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declared
ORA-06550: line 1, column 9:
PL/SQL: Statement ignored
"BEGIN SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('BII_EUPC.WARSM02"
"3','IBMPC/WIN_NT-8.1.0'); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 9:
PLS-00201: identifier 'SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declared
ORA-06550: line 1, column 9:
PL/SQL: Statement ignored
The connection to the database is with an O/S authenticated user (ops$osuser).
This user has the role IMP_FULL_DATABASE.
The package SYS.DBMS_DEFER_IMPORT_INTERNAL exists as is in VALID status.
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