Include the Checkpoint Table in the GLOBALS File

To specify the checkpoint table in the Oracle GoldenGate configuration:

  1. Create a GLOBALS file (or edit the existing one).
    EDIT PARAMS ./GLOBALS

    Note:

    EDIT PARAMS creates a simple text file. When you save the file after EDIT PARAMS, it is saved with the name GLOBALS in upper case, without a file extension. It must remain as such, and the file must remain in the root Oracle GoldenGate directory.

  2. In the GLOBALS file, enter the CHECKPOINTTABLE parameter.
    CHECKPOINTTABLE [container.]schema.table
    
  3. Save and close the GLOBALS file.