See 'Summary of Wildcard Exclusion Parameters' for more information. You can exclude objects from the schema specification by using the exclusion parameters. The ADD SCHEMATRANDATA command ensures replication continuity should DML occur on an object for which DDL has just been performed. If possible, use the ADD SCHEMATRANDATA command rather than the ADD TRANDATA command. See Installing and Configuring Oracle GoldenGate for Oracle Database for more information about how Oracle GoldenGate handles supplemental logging for Oracle databases. You can exclude the LONGVAR clause by using ADD TRANDATA with the EXCLUDELONG option.īy default, ADD TRANDATA for Oracle enables the unconditional logging of the primary key and the conditional supplemental logging of all unique key(s) and foreign key(s) of the specified table. By default, ADD TRANDATA issues the following command to the database:ĪLTER TABLE name DATA CAPTURE CHANGES INCLUDE LONGVAR COLUMNS

Use ADD TRANDATA to enable DATA CAPTURE CHANGES on specified tables. The ADD TRANDATA command calls STRJRNPF and is the recommended method to start journaling for tables, because it ensures that the required journal image attribute of Record Images (IMAGES): *BOTH is set on the STRJRNPF command.

Use ADD TRANDATA to start the journaling of data.

See the Oracle GoldenGate installation guide for your database for any special requirements that apply to making transaction information available. For other supported databases, this functionality may exist already or must be configured through the database interface. Use ADD TRANDATA to enable Oracle GoldenGate to acquire the transaction information that it needs from the transaction records.īefore using this command, use the DBLOGIN command to establish a database connection.ĪDD TRANDATA is valid only for the databases that are listed here.

Transdata geotab