CHECKPOINTTABLE

Valid For

GLOBALS

Description

Use the CHECKPOINTTABLE parameter in a GLOBALS parameter file to specify the name of a default checkpoint table that can be used by all Replicat groups in one or more Oracle GoldenGate instances. All Replicat groups created with the ADD REPLICAT command will default to this table unless it is overridden by using the CHECKPOINTTABLE option of that command.

To create the checkpoint table, use the ADD CHECKPOINTTABLE command. Oracle supports and recommends that a checkpoint table is created for Integrated Replicat.

See Add a Checkpoint Table for more information about creating a checkpoint table. Also see ADD CHECKPOINTTABLE

Default

None

Syntax

CHECKPOINTTABLE [container.] owner.table

[container.]owner.table

The owner and name of the checkpoint table. Additionally, for an Oracle container database, specify the correct pluggable database (container).

Example

CHECKPOINTTABLE finance.ggs.chkpt