- Oracle GoldenGate Classic Architecture Documentation
- Replicat
- Configuring Oracle GoldenGate Replicat
- About Checkpoint Table
- Adding the Checkpoint Table to the Target Database
Adding the Checkpoint Table to the Target Database
- 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.
-
- 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 ifschema.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.
-