Does OGG support Invisible Indexes in 11g db (文档 ID 1515952.1)
Oracle GoldenGate - Version 220.127.116.11.1 and later
Information in this document applies to any platform.
A new feature in Oracle 11g allows the creation of "invisible" indexes which means they are indexes
that we can choose when to expose to the optimizer when generating SQL plans. Current versions
of OGG do not support invisible indexes. So if only an invisible unique index is defined on a table,
OGG chooses not to see the unique index and treats this table as not having any unique index defined.
It is supported in OGG version 18.104.22.168.5 and higher. Support was added in following bug fix.
Bug 14099231 - SUPPORT ORACLE INVISIBLE INDEXES
The fix can be backported if needed. There is also a work-around of using KEYCOLS to force the
selection of invisible index columns.
BUG:15856355 - ORACLE GOLDENGATE V22.214.171.124.4_02 FOR ORACLE 11G ON LINUX X64