1.7 ALLOWINVISIBLEINDEXKEYS
Valid For
GLOBALS
Description
Use the ALLOWINVISIBLEINDEXKEYS
parameter in the GLOBALS
file to allow Extract and Replicat to use columns that are part of an Oracle invisible index as a unique row identifier.
Note:
To enable trigger-based DDL replication to use Oracle invisible indexes, set the following parameter to TRUE
in the params.sql script
:
define allow_invisible_index_keys = 'TRUE'
This functionality is automatically enabled for integrated capture and Replicat.
Default
None
Syntax
ALLOWINVISIBLEINDEXKEYS
Parent topic: Oracle GoldenGate Parameters