DROP REPLICATION
Removes
a replication from a table.
SYNTAX
| replication_name |
Name
of the synchronous table replication you want to remove. |
| table_name |
Name
of the table you want to remove the replication from. |
DESCRIPTION
The DROP
REPLICATION command removes an existing synchronous table replication
from the database. To execute the DROP REPLICATION command to drop a synchronous
table replication from a table you must be the table owner, or have DBA
or SYSADM security privileges.
A table
replication creates a full or partial copy of a table in a remote location.
This allows users in remote locations to work with a local copy of data.
The local copy remains synchronized with the databases in other locations.
This way each database can service data requests immediately and efficiently,
without having to go to another machine over a slower network connection.
This is not the same as backing up the database to a remote location,
since the synchronization is done on a transaction-by-transaction basis
by the DBMS itself, without any intervention from users.
There are
two primary types of table replication: synchronous and asynchronous.
Synchronous table replication modifies the remote table at the same time
it modifies the local table, while asynchronous table replication stores
changes to the local table and modifies the remote table based on a schedule.
The DROP REPLICATION command drops a synchronous table replications.
If you drop
a table or a column that is referenced by a replication, alter a table
and modify the column definition, or alter a table and add a column using
the BEFORE and AFTER keywords, the replication becomes invalid and cannot
be used again. Altering a table and adding a column without using the
BEFORE and AFTER keywords will have no impact on a replication. You can
drop an invalid replication to remove it from the database. Any replications
you create on a table are dropped automatically if you drop the table.
EXAMPLE
The following
example drops the replication named EmpRep from the Employees table.
DROP REPLICATION EmpRep From Employees
|
RELATED COMMANDS
<
DROP LINK | Contents
| DROP SYNONYM >
|
