PowerExchange Express CDC for Oracle Configuration File
PowerExchange Express CDC for Oracle Configuration File
PowerExchange 10.2 introduces a new parameter for the OPTIONS statement in the PowerExchange Express CDC for Oracle configuration file, pwxorad.cfg.
OPTIONS Statement
You can now specify the following optional parameter in the statement:
REPORTDDL={Y|
N
}
New.
Controls whether PowerExchange Express CDC reports all of the DDL operations that it encounters in the Oracle redo logs for Oracle source tables with active capture registrations. Express CDC writes the following information for each DDL operation to a file that is generated in the directory from which Express CDC runs: the DDL statement, log position, owner number, DDL object number, and sequence number. The file naming conventions are:
For RAC systems:
PWX_ORL_DDL_D
yyyymmdd
_T
hhmmss
.MBR
node
_sequence#.rpt
For non-RAC systems:
PWX_ORL_DDL_D
yyyymmdd
_T
hhmmss
.
sequence#
.rpt
In these file names,
sequence#
is a generated number that starts from 0001 and that is incremented by 1 for each new file. A new file is generated every 20 MB of DDL change records.
Options are:
Y
. Generate the report of DDL operations for registered source tables.
N
. Do not generate the report of DDL operations.
Default is N.
For more information, see the "Express CDC for Oracle" chapter in the
PowerExchange CDC Guide for Linux, UNIX, and Windows