IMP-3 ORA-6550 PLS-201 SYS.DBMS_DEFER_IMPORT_INTERNAL Raised When Connecting With An OS Authenticated User (Doc ID 353771.1)

Last updated on MARCH 13, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 7.3.3.0 and later
Information 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


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