Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

X_$KGLOB became invalid after upgrading from Oracle 12.1 to 12.2

edited Mar 11, 2019 10:48AM in Database Install/Upgrade/Opatch (MOSC) 6 commentsAnswered ✓

Hi,

We just upgrade from Oracle 12.1 to 12.2 and this view x_$kglob becomes invalid and below is the reason

SQL> select text from user_errors where name='X_$KGLOB';

TEXT
--------------------------------------------------------------------------------
ORA-00904: "KGLOBT24": invalid identifier

I don't know how to correct this. The base table X$KGLOB is not visible and tried to search in $ORACLE_HOME/rdbms/admin for possible DDL of this view but I unable to find it. The view x_$kglob is used in a lot of scripts in that directory.

if anyone could give me the DDL of this view for version 12.2, will be greatly appreciated.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center