Enable TRANDATA or SCHEMATRANDATA for Oracle Database
This can be done at the table, schema, or global (database) level.
To enable supplemental logging, connect to the database from the DB Connections page, select the Trandata menu, then perform the following steps:
- Select the Table or Schema option as required and click plus sign to add.
- Enter the name of the table for which you need to set up
supplemental logging. Make sure to enter the full table name with schema name,
such as,
HR.EMP
. You can also use wildcard instead of specific table name. - Click Submit.
You can skip ADD TRANDATA
in case of initial load
without CDC.
You can also use the commands ADD TRANDATA
and
ADD SCHEMATRANDATA
for setting up trandata and schema level
trandata. For details, see ADD TRANDATA
and ADD
SCHEMATRANDATA
in Command Line Interface
Reference for Oracle GoldenGate.
Note:
Before you run theADD
TRANDATA
command, you need to first connect to the database where the
Extract will be added, using the DBLOGIN
command. In addition, run
the ADD TRANDATA
or ADD SCHEMATRANDATA
commands
before adding the Extract.