[Translated from mos] Does OGG support invisible indexes in oracledb11g?

[Translated from mos] Does OGG support invisible indexes in oracledb11g?

Source:

Does OGG support Invisible Indexes in Oracle 11g db (Document ID 1515952.1)

Applies:

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

Selection of invisible index columns.

REFERENCES

BUG: 15856355-oracle goldengate V11.2.1.0.4 _ 02 for oracle 11g on linux X64