Adding the Checkpoint Table to the Target Database

  1. From the Oracle GoldenGate directory on the target, run GGSCI and issue the DBLOGIN command to log into the target database.
    DBLOGIN USERIDALIAS alias

    Where:

    • alias specifies the alias of the database login credential of a user that can create tables in a schema that is accessible to Replicat. This credential must exist in the Oracle GoldenGate credential store. For more information, see Establishing Oracle GoldenGate Credentials.

  2. In GGSCI or Admin Client, create the checkpoint table in a schema of your choice (ideally dedicated to Oracle GoldenGate). 
    ADD CHECKPOINTTABLE [container.]schema.table

    Where:

    • container is the name of the container if schema.table is in a multitenant container database. This container can be the root container or a pluggable database that contains the table.

    • schema.table are the schema and name of the table. See Administering Oracle GoldenGate for instructions for specifying object names.