2.96 UPGRADE HEARTBEATTABLE

Valid for Oracle, PostgreSQL.

Use UPGRADE HEARTBEATTABLE to alter heartbeat tables and lag views created with an Oracle GoldenGate release before 19c to add extra columns. These extra columns are used to track the Extract restart position. This command fails in a heartbeat setup in which the tables and views already have the extra columns.

This command requires a DBLOGIN. On a CDB database, a PDB login is required.

(PostgreSQL) Use this command to add the LOGBSN columns to the heartbeat tables.

Syntax

UPGRADE HEARTBEATTABLE