Oracle - Oracle Server supports two different forms of replication posted by
Babu Kunwar
Oracle Server supports two different forms of replication: basic and advanced
replication. Explain difference between these.
Basic replication is implemented using standard CREATE SNAPSHOT or CREATE
MATERIALIZED VIEW statements. It can only replicate data and not procedures,
indexes replication is always one-way, and snapshot copies are read only.
Advanced replication supports various configurations of updatable snapshot,
multi-master and update anywhere replication. It is more difficult to configure
but allows data and other database objects like indexes and procedures to be
replicated.
With basic replication, data replicas provide read-only access to the table
data whereas advanced replication features extend the capabilities of basic
read-only replication by allowing applications to update table replicas
throughout a replicated database system.
With Basic Replication applications can query data from local data replicas. On
the other hand with advanced replication, data replicas anywhere in the system
can provide both read and update access to a table's data.
More links
Conditional control: IF and CASE Statements.
Iterative Control: LOOP and EXIT Statements.
GOTO statement takes the control to the labeled statement............
|
