【翻译自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 - ORACLE GOLDENGATE V11.2.1.0.4_02 FOR ORACLE 11G ON LINUX X64