how to delete replicat?
edited Dec 4, 2013 1:06AM in GoldenGate, Streams and Distributed Database (MOSC) 6 commentsAnswered ✓
.
how to sucessful delete replicat <replicte_name> 、<table_name>. I wnat to rebuild <replicte_name> 、<table_name>.
GGSCI (lhcld39-ms04) 29> add checkpointtable test1
ERROR: Creating checkpoint table 'test1'.
Database error 1050 (Table 'test1' already exists).
GGSCI (lhcld39-ms04) 30> add replicat rggs, exttrail /ggs/dirdat/et checkpointtable test1
ERROR: REPLICAT RGGS already exists.
GGSCI (lhcld39-ms04) 31> delete replicat rggs
ERROR: Could not delete DB checkpoint for REPLICAT RGGS (Deleting entry in checkpoint table 'test.CHECKPOINT' (group: 'RGGS', key: '1249765862' ).
Database error 1146 (Table 'test.CHECKPOINT' doesn't exist)).
0