Invalid x_$ Objects After Upgrade
(Doc ID 361757.1)
Last updated on JULY 05, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 8.1.7.4 to 19.3.0.0.0 [Release 8.1.7 to 19]Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
You have successfully completed a database upgrade without any errors, but notice that there are some invalid SYS owned objects that begin with x_$. For example:
Note: These objects may be named in upper, lower or mixed case and are usually views starting with the x_$
sys x_$bh
sys x_$kcbwbpd
sys x_$kcbwds
If you try to recompile these views manually, you receive a warning similar to the following:
alter view x_$bh compile;
warning : view altered with compilation errors.
- show errors;
No errors.
If you try to recompile other invalid views or procedures, you may get errors like ORA-904 and ORA-907.
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 |
References |