KEYCOLS Option For DEFGEN Utility (Doc ID 2177933.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.0.9 to 12.1.2.1.9 [Release 12.1]
Information in this document applies to any platform.

Goal

Currently, DEFGEN utility marks all columns from either Primary Key or from any unique index(es) if PK is missing, as key columns in generated source definition for the table. However, there is no way to instruct DEFGEN to mark only the user specified columns.

Implemented new option of Keycols from OGG 12.1.2.1.99 version 

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms