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:

  1. Select the Table or Schema option as required and click plus sign to add.
  2. 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.
  3. 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 the ADD 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.