1.60 EXCLUDEHIDDENCOLUMNS

Valid For

Oracle Integrated Extract Capture; It’s not valid for data pump.

Description

The parameter disables all the Oracle hidden columns including the timestamp columns created using automatic CDR. The parameter requires Oracle GoldenGate 12c (12.2.01) format trail or higher and must not specify the NO_OBJECTDEFES parameter. The userexit callback structure has the hidden column attributes and callback structure version is 5. You can specify the parameter at any location of the parameter file, as long as it is after the EXTRACT group parameter.

Syntax

EXTRACT ext1...
EXCLUDEHIDDENCOLUMNS
EXTTRAIL ./dirdat/a1
TABLE src.tab1;