Valid for all supported databases. See the Certification Matrix for details on supported databases.

Use UPGRADE HEARTBEATTABLE when upgrading Oracle GoldenGate from a prior release, to enable any new heartbeat functionality available in the current release.

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

Oracle GoldenGate for Oracle database simplifies the administration of the heartbeat table by eliminating the need for GGSCHEMA or HEARTBEATTABLE parameter. In case of CDB root Extract, GGSCHEMA is used.

Syntax

UPGRADE HEARTBEATTABLE