DELETE HEARTBEATTABLE
Valid for all supported databases. See the Certification Matrix for details on supported databases.
Use DELETE HEARTBEATTABLE to delete tables, procedures,
schedulers, and views. This command requires a DBLOGIN. On a CDB
database, a PDB login is required.
Syntax
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.
DELETE HEARTBEATTABLE heartbeattable_name