Deleting Extract and Replicat

This section contains basic directions for deleting Extract and Replicat processes.

To Delete an Extract Group

  1. Connect to the deployment from the Admin Client.

  2. 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]}
  3. Stop the Extract process.

    STOP EXTRACT group_name
  4. Issue the following command.

    DELETE EXTRACT group_name
  5. (Oracle) Unregister the Extract group from the database.

    UNREGISTER EXTRACT group_name,database_name

To Delete a Replicat Group

  1. Stop the Replicat process.
    STOP REPLICAT group_name
  2. 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:

    • 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.

  3. 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.