Deleting Extract and Replicat
This section contains basic directions for deleting Extract and Replicat processes.
To Delete an Extract Group
-
Connect to the deployment from the Admin Client.
-
Issue the
DBLOGINcommand 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 to log into the database.
DBLOGIN [SOURCEDB *dsn*] {USERID *user*, PASSWORD *password* [*encryption_options*] | USERIDALIAS *alias* [DOMAIN *domain*]}Where:
-
SOURCEDBdsn supplies the data source name, if required as part of the connection information. -
USERIDuser,PASSWORDpassword specifies an explicit database login credential. -
USERIDALIASalias[DOMAINdomain]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.