Oracle - Describe how to set up multi-master replication. posted by
Babu Kunwar
Describe how to set up multi-master replication.
Following is the query to setup multi-master replication:
Run ?/rdbms/admin/catrep.sql as user SYS AS SYSDBA.
Remember that the SID for each database must be unique. INIT.ORA parameters
JOB_QUEUE_PROCESSES and JOB_QUEUE_INTERVAL need to be set if you want to
schedule replication automatically.
GLOBAL_NAMES must be set to TRUE if you are using the Oracle Replication
Manager GUI.
One can use the OEM Replication Manager to configure replication or by issuing
PL/SQL API calls. Look at these sample Replication Scripts.
More links
Define PL/SQL. Explain its purpose
Advantages of PL/SQL
Main Features of PL/SQL
PL/SQL Architecture
Basic Structure of PL/SQL
Variables and Types............ .
|
