Using KEYCOLS
to Specify a Custom Key
If a table does not have an applicable row identifier, or if you prefer that
identifiers are not used, you can define a substitute key, providing that the table has
columns that always contain unique values. You define this substitute key by including a
KEYCOLS
clause within the Extract TABLE
parameter
and the Replicat MAP
parameter. The specified key overrides any
existing primary or unique key that Oracle GoldenGate finds.