Synchronous Table Replication |
|
Table replication is used to ensure consistency of data across multiple databases. Synchronous means the modification to the remote site is immediate. The replication modifies the remote table at the same time it modifies the local table. Thus, after establishing a replication, any update on the source table will become a DDB (distributed database) action. This affects the local database's behavior; if the remote database server is cannot be contacted, an update on local database will fail.
Related topic:
Working
with Database Links
Asynchronous Table Replication
Adding Synchronous Table Replication
Adding Subscribers to a Synchronous Replication