X_$KGLOB became invalid after upgrading from Oracle 12.1 to 12.2
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.