2.5 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