Invalid XDB related Procedures SYS.XDB$MIGRATEXMLTABLE and SYS.CREATE_CSXINVALID_ENTRIES_TAB After Upgrade To 11g
(Doc ID 868712.1)
Last updated on FEBRUARY 01, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.2.0 [Release 11.1 to 11.2]Oracle Database Cloud Schema 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
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
XDB component was recently upgraded to the 11g database. There are now two invalid XDB related
procedures owned by SYS.
XDB$MIGRATEXMLTABLE
CREATE_CSXINVALID_ENTRIES_TAB
When trying to compile these objects the following is returned:
SQL> alter PROCEDURE XDB$MIGRATEXMLTABLE compile;
Warning: Procedure altered with compilation errors.
SQL> show error
Errors for PROCEDURE XDB$MIGRATEXMLTABLE:
LINE/COL ERROR
-------- -----------------------------------------------------------------
225/5 PL/SQL: Statement ignored
225/5 PLS-00905: object SYS.CREATE_CSXINVALID_ENTRIES_TAB is invalid
SQL> alter PROCEDURE CREATE_CSXINVALID_ENTRIES_TAB compile;
Warning: Procedure altered with compilation errors.
SQL> show error
Errors for PROCEDURE CREATE_CSXINVALID_ENTRIES_TAB:
LINE/COL ERROR
-------- -----------------------------------------------------------------
151/7 PL/SQL: Statement ignored
151/7 PLS-00201: identifier 'XDB.FIXACL_SCHEMALOC' 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 |