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
-
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
withDATABASE
, do the following:-
Stop Extract with the
STOP EXTRACT
command. -
Log in to the mining database with the
DBLOGIN
orMININGDBLOGIN
command with the privileges granted in thedbms_goldengate_auth.grant_admin_privilege
procedure. For local capture,DBLOGIN
is required. For downstream capture,DBLOGIN
andMININGDBLOGIN
are both required. -
Delete the Extract group with
DELETE EXTRACT
.
-