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
Parent topic: Common Command Line Interface Commands