Not valid for Replicat for Java, Oracle GoldenGate Applications Adapter, or Oracle GoldenGate for Big Data.
CHECKPOINTTABLE to create a checkpoint table in the target
database. Replicat uses the table to maintain a record of its read position in the
trail for recovery purposes.
The use of a checkpoint table is strongly recommended, because it causes checkpoints to be part of the Replicat transaction. This allows Replicat to recover more easily in certain circumstances than when a checkpoint file alone is used.
One table can serve as the default checkpoint table for all Replicat
groups in an Oracle GoldenGate instance if you specify it with the
CHECKPOINTTABLE parameter in a
More than one instance of Oracle GoldenGate (multiple installations) can use the
same checkpoint table. Oracle GoldenGate keeps track of the checkpoints even when
the same Replicat group name exists in different instances.
DBLOGIN command to establish a database
connection before using this command. Do not change the names or attributes of the
columns in this table. You may, however, change table storage attributes.
See About Checkpoints.
Admin Client Syntax
ADD CHECKPOINTTABLE [[container. | catalog.] owner.table]
The name of the checkpoint table to be created. The name cannot contain any special characters, such as quotes, backslash, dollar sign, and percent symbol. Record the name of the table, because you need it to view statistics or delete the table if needed.
For PostgreSQL in Oracle GoldenGate 19c (19.1.0), the table and schema for the checkpoint table must be in lower case without quotes in it.
ADD CHECKPOINTTABLE [[container. | catalog.]owner.table]
The Oracle pluggable database, if applicable. If this option is omitted, the pluggable database defaults to the one that is associated with the
USERIDALIASportion of the
DBLOGINcommand (depending on the database).
The owner and name of the checkpoint table to be created. The name cannot contain any special characters, such as quotes, backslash, dollar sign, and percent symbol. The name of a MySQL checkpoint table can contain no more than 30 characters.
The owner and name can be omitted if you are using this table as the default checkpoint table and it is listed with
It is recommended, but not required, that the table be created in a schema dedicated to Oracle GoldenGate. If an owner and name are not specified, a default table is created based on the
CHECKPOINTTABLEparameter in the
Record the name of the table, because you will need it to view statistics or delete the table if needed. In MA, the default schema for the checkpoint table is controlled by the Oracle GoldenGate user that is defined for each deployment. See step 7 of the How to Create Deployments procedure described in the Using Oracle GoldenGate Microservices Architecture guide.