Re: Controlling Replication

From: BN.Sarma <bsarma_at_basit.com>
Date: 6 Feb 2003 08:43:46 -0800
Message-ID: <e20868e8.0302060843.bf3128a@posting.google.com>

Greetings,

You can use dbms_reputil.replication of before any dml like INSERT/UPDATE/DELTE. It is session specific.

If this is a regular one, I suggest you to go for partitions, the way you have explained, you can take advantage of partitions. you can truncate the required parition and keep the other one intact. DDLs are not rteplicated.

Partitions might help your quries run faster and better maintenance. You need to do a benchmark with and without partitions efore implementing it into practice.

Regards & Thanks
BN Received on Thu Feb 06 2003 - 10:43:46 CST