QuestionQ27

Configuration Options

Replicat creates checkpoints in the trail file to record its most recently read position. Select two methods for creating checkpoint tables.

Choose two
  • A Run the chkpt_db_extracttrail.sql script.
  • B Run the chkpt_db_create.sql script.
  • C Use the ADD Extract Trail command.
  • D Use the INFO REPLICAT command with the SHOWCH option.
  • E Use the ADD CHECKPOINTTABLE command.
Explanation

Oracle GoldenGate checkpoint tables can be created either by running the database-specific chkpt_db_create.sql script or by issuing the ADD CHECKPOINTTABLE command. These tables store Replicat progress for recovery.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!