Hi all,
I'm having trouble deleting a replicat. This might be simple, but I'm having a tough time
ggsci> delete replicat rsamp2
ERROR: Could not delete DB checkpoint for REPLICAT RSAMP2 (OCI Error ORA-00942: table or view does not exist (status = 942). Deleting from checkpoint table CHKPTABLE, group 'RSAMP2', key 1302903318 (0x4da8ba16), SQL <DELETE FROM CHKPTABLE WHERE group_name = 'RSAMP2' AND group_key = 1302903318>).
ggsci> info rsamp2,detail
REPLICAT RSAMP2 Initialized 2013-08-09 19:15 Status STOPPED
Checkpoint Lag 00:00:00 (updated 92:58:33 ago)
Log Read Checkpoint File ./dirdat/p5000000
First Record RBA 0
Extract Source Begin End
./dirdat/p5000000 * Initialized * First Record
./dirdat/sp000000 * Initialized * First Record
Current directory /opt/gg
Report file /opt/gg/dirrpt/RSAMP2.rpt
Parameter file /opt/gg/dirprm/rsamp2.prm
Checkpoint file /opt/gg/dirchk/RSAMP2.cpr
Checkpoint table CHKPTABLE
Process file /opt/gg/dirpcs/RSAMP2.pcr
Stdout file /opt/gg/dirout/RSAMP2.out
Error log /opt/gg/ggserr.log
I tried creating a new checkpoint and alter the rsamp2 replicat and then delete by:
ggsci>alter replicat rsamp2, exttrail ./dirdat/sp, checkpointtable sam2chk
ERROR: Invalid parameter specified for ALTER REPLICAT.
Please help me out here, appreciate your help
Thanks,
Vikas