【翻译自mos文章】OGG支持oracle db 11g中的不可见索引吗？

来源于： Does OGG support Invisible Indexes in Oracle 11g db (文档 ID 1515952.1) ### APPLIES TO: Oracle GoldenGate - Version 11.2.1.0.1 and later Information in this document applies to any platform. ### GOAL 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. ### FIX It is supported in OGG version 11.2.1.0.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. ### REFERENCES [BUG:15856355](https://support.oracle.com/epmos/faces/BugDisplay?parent=DOCUMENT&sourceId=1515952.1&id=15856355) - ORACLE GOLDENGATE V11.2.1.0.4_02 FOR ORACLE 11G ON LINUX X64