2.93 UNREGISTER EXTRACT

Valid for Oracle and PostgreSQL.

Use UNREGISTER EXTRACT to remove the registration of an Extract group from an Oracle database. UNREGISTER EXTRACT is valid only for a primary Extract group. Do not use it for a data pump Extract.

To register an Extract group with the database, use the REGISTER EXTRACT command.

To upgrade an Extract from classic capture mode to integrated capture mode, use the ALTER EXTRACT command.

For PostgreSQL, a replication slot is dropped in the connected database for PostgreSQL. This command ensures that the PostgreSQL database overwrites the existing transaction log or may archive the log . After deleting the Extract, the command must be run.

Syntax

UNREGISTER EXTRACT group_name
{DATABASE  | LOGRETENTION}

group_name

The name of the Extract group that is to be unregistered from the database. Do not use a wildcard. This group must currently be registered with the database.

DATABASE

(Oracle only) Disables integrated capture mode for the Extract group.

(Oracle only) This command removes the database capture (mining) server that has the same name as the Extract group. For additional information about support for, and configuration of, the Extract capture modes.

Before using UNREGISTER EXTRACT with DATABASE, do the following:

1. Stop Extract with the STOP EXTRACT command.

2. Log in to the mining database with the DBLOGIN or MININGDBLOGIN command with the privileges granted in the dbms_goldengate_auth.grant_admin_privilege procedure. For local capture, DBLOGIN is required. For downstream capture, DBLOGIN and MININGDBLOGIN are both required.

3. Delete the Extract group with DELETE EXTRACT.

LOGRETENTION

Valid for Oracle only.

Disables log retention for the specified Extract group and removes the underlying Oracle Streams capture process. Use UNREGISTER EXTRACT with LOGRETENTION only if you no longer want to capture changes with this Extract group. The log-retention feature is controlled with the LOGRETENTION option of the TRANLOGOPTIONS parameter.

Before using UNREGISTER EXTRACT with LOGRETENTION, stop Extract with the STOP EXTRACT command. Next, issue the DBLOGIN command with the privileges granted in the dbms_goldengate_auth.grant_admin_privilege procedure.

Examples

UNREGISTER EXTRACT sales LOGRETENTION

UNREGISTER EXTRACT sales DATABASE

UNREGISTER EXTRACT Extract1 with DATABASE PostgresDB1