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 laterOracle 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
"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! |