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