Some Rows Are Missing In $K Table After Manual Sync Of Index With SMALL_R_ROW Enabled
(Doc ID 2368538.1)
Last updated on MARCH 26, 2018
Applies to:Oracle Text - Version 12.2 BETA1 and later
Information in this document applies to any platform.
After synchronizing Oracle Text indexes, dr$pending and dr$waiting are empty, however, not all rows are in the $K table.
If some of the missing rows are updated, not all of them appear in dr$pending / dr$waiting. The rows are stuck in the $U table.
Additional syncing does not change the situation and rowids are stuck in $U forever preventing the part of new rows to be indexed.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!