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
Database on other servers can be updated and those transactions can be grouped together with others in a logical unit.Database uses a two phase commit.
A distributed database is a network of databases managed by multiple database servers that appears to a user as single logical database.
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
Prepare phase - The global coordinator (initiating node) ask a participants to prepare (to promise to commit or rollback the transaction, even if there is a failure) Commit
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
View page << Previous 1 [2]
Go Top
