Missing $U Table after migration from 11.2.0.4 to 12.2.0.1
Hi Community,
Oracle introduces the $U Table for Oracle Text (https://docs.oracle.com/en/database/oracle/oracle-database/12.2/ccapp/changes-in-this-release.html#GUID-E22689A5-29B0-4B…
Sadly this Table is not generated during Migration. This leads to Max Cursor Issues with our Application as mentioned here: ORA-01000 maximum open cursors exceeded after migration to Oracle 12c
Rebuild the Index is an Option, but not a good one for our Customers since this takes days. I also tried using the ctx_ddl.optimize_index in optimize level REBUILD. But his does not create the missing $U Table.
I also contacted the ORacle Support, but there solution is to rebuild the Index.