Invalid x_$ Objects After Upgrade
Last updated on MARCH 20, 2017
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 8.1.7 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 20-Mar-2017***
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_$
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;
If you try to recompile other invalid views or procedures, you may get errors like ORA-904 and ORA-907.
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 hundreds of Community platforms