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.

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:vvnrk2005yahoo.co.uk] 
Sent: 05 May 2007 09:04 AM
To: suse-oraclesuse.com
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-unsubscribesuse.com
For additional commands, email: suse-oracle-helpsuse.com
Please see http://www.suse.com/oracl
e/ before posting