INFO HEARTBEATTABLE

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

Use INFO HEARTBEATTABLE to display information about the heartbeat tables configured in the database.

This command requires a DBLOGIN. For an Oracle multitenant database, the DBLOGIN to a PDB is required.

Oracle GoldenGate for Oracle AI Database simplifies the administration of the heartbeat table by eliminating the need for GGSCHEMA or HEARTBEATTABLE parameter. To implement this, Extracts and Replicat look in the schema of the ER processes connected user for the heartbeat tables, except for Oracle CDB root Extract. In case of CDB root Extract, GGSCHEMA is used. In case of Autonomous AI Database, the user must be GGADMIN.

Syntax

INFO HEARTBEATTABLE