Deleting Extract and Replicat

This section contains basic directions for deleting Extract and Replicat processes. See Reference for Oracle GoldenGate for additional command options.

To Delete an Extract Group

Run GGSCI.
Issue the DBLOGIN command as the Extract database user (or a user with the same privileges). You can use either of the following commands, depending on whether a local credential store exists.
```
DBLOGIN [SOURCEDB dsn] {USERID user, PASSWORD password [encryption_options] | USERIDALIAS alias [DOMAIN domain]}
```
Stop the Extract process.

STOP EXTRACT group_name
Issue the following command.

DELETE EXTRACT group_name
(Oracle) Unregister the Extract group from the database.
```
UNREGISTER EXTRACT group_name,database_name
```

To Delete a Replicat Group

Stop the Replicat process.

STOP REPLICAT group_name
Issue one of the following commands from GGSCI to log into the database.
```
DBLOGIN [SOURCEDB dsn] {USERID user, PASSWORD password [encryption_options] | USERIDALIAS alias [DOMAIN domain]}
```
Where:
- SOURCEDB dsn supplies the data source name, if required as part of the connection information.
- USERID user, PASSWORD password specifies an explicit database login credential.
- USERIDALIAS alias [DOMAIN domain] specifies an alias and optional domain of a credential that is stored in a local credential store.
- encryption_options is one of the options that encrypt the password.
Issue the following command to delete the group.

DELETE REPLICAT group_name

Deleting a Replicat group preserves the checkpoints in the checkpoint table (if being used). Deleting a process group also preserves the parameter file. You can create the same group again, using the same parameter file, or you can delete the parameter file to remove the group's configuration permanently.