Two-phase commit is mechanism that guarantees a distributed transaction either commits on all involved nodes or rolls back on all involved nodes to maintain data consistency
Snapshots and SNAPSHOT LOGs
Snapshots are read-only copies of a master table located on a remote node which is periodically refreshed to reflect changes made to the master table.
A snapshot log is a table in the master database that is associated with the master table. ORACLE uses a snapshot log to track the rows that have been updated
SQL *NET is ORACLE's mechanism for interfacing with the communication protocols used by the networks that facilitate distributed processing and distributed
- Replication of data in distributed environment. - Using snapshots to replicate data. - Using remote procedure calls.
Updating or Inserting records in remote database through database triggers. It may fail if remote database is having any problem.
It is a table that maintains a record of modifications to the master table in a snapshot. It is stored in the same database as master table and is only available
We must be able to create a after row trigger on table (i.e., it should be not be already available) After giving table privileges. We cannot specify snapshot log name because oracle uses
