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.
See Installing and Configuring Oracle GoldenGate for Oracle Database for more information about configuring and registering Oracle GoldenGate for an Oracle database.
UNREGISTER EXTRACT group_name
{DATABASE | LOGRETENTION}
group_nameThe 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.
DATABASEDisables integrated capture mode for the Extract group.
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, see Installing and Configuring Oracle GoldenGate for Oracle Database.
Before using UNREGISTER EXTRACT with DATABASE, do the following:
Stop Extract with the STOP EXTRACT command.
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.
Delete the Extract group with DELETE EXTRACT.
LOGRETENTIONDisables 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 shown in 1–2.