My Oracle Support Banner

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 JANUARY 30, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 7.3.3.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud 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
Information in this document applies to any platform.

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('<GLOBAL_NAME>','<NAME>'); 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.

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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.