1. Oracle GoldenGate Classic Architecture Documentation
  2. Prepare
  3. Prepare Your Database for Oracle GoldenGate Classic Architecture
  4. Teradata
  5. Understanding What's Supported for Teradata
  6. Supported Objects and Operations for Teradata

Supported Objects and Operations for Teradata

This section lists the data operations and database objects that Oracle GoldenGate supports.

  • Oracle GoldenGate supports the maximum number of columns per table that is supported by the database.

  • Truncating operations are supported with the use of the GETTRUNCATES parameter with Oracle GoldenGate 12.2.x and greater.

  • Limitations on Automatic Heartbeat Table support are as follows:

    • The ALTER HEARTBEATTABLE command is not supported and if used is ignored.

    • The ADD HEARTBEATTABLE command with the FREQUENCY, PURGE_FREQUENCY, or RETENTION_TIME option is not supported. When any of these options are specified with the ADD HEARTBEATTABLE command, a warning is displayed that the option is ignored.

    • Since Teradata does not have any internal event/job schedulers, automatic purging of heartbeat history data does not occur. You need to explicitly delete or truncate records periodically from the heartbeat history table.