Hi Venkat

A couple of tips.
1) Follow Oracle's documentation, and setup the repadmin user propperly.
2) All tables added to replication should have a single numeric primary key
(optimal efficiency)
3) Avoid triggers on replication tables, triggers can lead to data loss if
triggered from a replication table to another replication table, directly or
indirectly.
4) Be patient when setting up replication, especially if you are adding
tables with data in them. Don't rush it along, just let it complete in its
own time.
5) Once running, check that the replication jobs doesn't go "Broken".
6) Try to use a separate schema (not repadmin) for all the objects that
require to be replicated.

Cheerio
CJ



-----Original Message-----
From: Venkat Rao [mailto:vvnrk2005@(protected)]
Sent: 05 May 2007 09:04 AM
To: suse-oracle@(protected)
Subject: [suse-oracle] Tips on Advanced Replication

Hi All,
 
Can any one give me some setup tips/issues that had been faced in setting
up the advanced replication in oracle 9i?
 
with many thanks in advance.
 
venkat
 

   
---------------------------------
What kind of emailer are you? Find out today - get a free analysis of your
email personality. Take the quiz at the Yahoo! Mail Championship.



--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting