Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Golden gate missing checkpoint table

ExorAug 16 2010 — edited Mar 25 2013
Hello 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,
This post has been answered by Pradeep Gupta on Aug 17 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 22 2013
Added on Aug 16 2010
9 comments
15,834 views