| udaseen_laxmi |
Posted: Jun 23, 2003 04:09:00 PM |
Total Post: 17
Joined: Jan, 2003
|
I want to setup replication for one of my databases. Can someone please explain the advantage and disadvantage of it and if possible the necessary steps to setup it? I am on Oracle 8.1.7.4
Thanks in advance.
Anil
|
|
|
 Sabari Nath |
| Posted: Jun 24, 2003 11:00:00 AM |  |
|
Total Post: 16
Joined: Jan, 2003
|
If you have access to metalink then read Note:117434.1
Subject: Initial Steps Required to a Create Multi Master Replication Environment v8.1 / v9.x
Regards,
Vasu
|
|
|
|
|
| Jovih |
| Posted: Jul 21, 2003 07:41:00 AM | |
|
Total Post: 5
Joined: Jan, 2003
|
For Replication;
1) Make an entry in the TNSNAMES.ORA
2) Create a database link
create database link xyz
connect to abc
identified by abc
using 'xxx' ;
3) You need to create snapshot log;
3) Create a snapshot;
create snapshot aaa refresh [fast/complete]
[with rowid ]
for select * from aaa@xyz ;
if table does not have primary key then select
option ' with rowid '
Options;
---------
Fast : only modifications will takes place;
complete : It will refresh the entire table.
You have to create triggers on SNAP$ tables to populate new data to the existing tables;
Before insert or update or delete trigger on SNAP$.
:)
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
