XDB Invalid after deinstalling and reinstalling error PLS-00201: identifier 'DBMS_LOB' must be declared
(Doc ID 1428673.1)
Last updated on JANUARY 17, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.4 [Release 11.2]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
After deinstalling and reinstalling XDB it became invalid
In the XDB installation there are errors
SYS:cdrspp1:SQL> CREATE OR REPLACE PACKAGE BODY xdb.DBMS_XMLDOM wrapped
2 a000000
...
...
Warning: Package Body created with compilation errors.
SYS:cdrspp1:SQL> show errors;
Errors for PACKAGE BODY XDB.DBMS_XMLDOM:
LINE/COL ERROR
-------- -----------------------------------------------------------------
935/4 PL/SQL: Statement ignored
935/37 PLS-00201: identifier 'DBMS_LOB' must be declared
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! |
In this Document
| Symptoms |
| Cause |
| Solution |