Golden gate missing checkpoint table
ExorAug 16 2010 — edited Mar 25 2013Hello gurus,
I am trying to implement live replication with Golden Gate but I can't create the checkpoint table.
GGSCI () 26> ADD CHECKPOINTTABLE
ERROR: Missing checkpoint table specification.
GGSCI (q) 27> ADD REPLICAT rep1, EXTTRAIL /t01/software/gg2/dirdat/rt
ERROR: No checkpoint table specified for ADD REPLICAT.
GGSCI () 28> ADD CHECKPOINTTABLE
ERROR: Missing checkpoint table specification.
GGSCI (qcdvap1031.gnet.qc.bell.ca) 29> edit ./GLOBALS
ERROR: Invalid command.
GGSCI () 30> edit params ./GLOBALS
GGSCHEMA GGS_OWNER
CHECKPOINTTABLE GGS_OWNER.CHKPTAB
GGSCI (q) 31> ADD CHECKPOINTTABLE GGS_OWNER.CHKPTAB
Successfully created checkpoint table GGS_OWNER.CHKPTAB.
GGSCI () 32> ADD REPLICAT rep1, EXTTRAIL /t01/software/gg2/dirdat/rt
ERROR: No checkpoint table specified for ADD REPLICAT.
Not sure what I am missing here, can anyone please help?
Thank you very much,