1. Oracle GoldenGate Classic Documentation
  2. Prepare
  3. Prepare Your Database for Oracle GoldenGate Classic Architecture
  4. PostgreSQL
  5. Configuring Replicat
  6. Prerequisites for Creating a Replicat
  7. Creating a Checkpoint Table

Creating a Checkpoint Table

A checkpoint table is used by a Replicat in the target database for recovery positioning when restarting a Replicat. A checkpoint table is optional (but recommended) for a Classic Replicat and required for a Coordinated Replicat.

The checkpoint table needs to be created under an existing schema in the database and by default will attempt to create the table in the schema listed in the GLOBALS file, GGSCHEMA parameter. Ensure that the schema listed in GLOBALS exists in the database and that the Replicat user has permissions to use the schema and create tables in it.

These steps demonstrate creating a checkpoint table for a Classic and Coordinated Replicat.

  1. Using GGSCI, connect to the DSN for the target database.

    GGSCI> DBLOGIN SOURCEDB dsn USERIDALIAS alias

  2. Add the checkpoint table using the GGSCI command.

    GGSCI> ADD CHECKPOINTTABLE ggadmin.oggcheck