To delete extract/replicat, if simple delete command is not working, then we can do it forcibly by adding exclamation mark (!) at the end.
1. How to stop extract/replicat?
kill extract group_name
kill replicat group_name
2. How to delete extracat / replicat
delete extract group_name [!]
delete replicat group_name [!]
3. How to cleanup ( stop first)
cleanup extract group_name
cleanup replicat group_name
GGSCI (XXXn1) 27> delete replicat r_XXX
ERROR: Could not delete DB checkpoint for REPLICAT R_XXX (SQL operation failed: Deleting from checkpoint table GGATE.CHECKPOINT, group R_XXX, key 2648753342 (0x9de0c4be), SQL SQL Error 972: ORA-00972: identifier is too long).
GGSCI (xxn1) 35> delete replicat r_XXX !
ERROR: REPLICAT R_XXX does not exist.