Data Replication on Oracle DB

[akelkar]

Hey

If any one can help me on data replication on Oracle 8i DB. Precisley I
want to do :

1. Replicate the data from one set of tables to another set of tables in
a seperate DB instance. The replication should only work for inserts
and updates. That is it should only replicate the data for inserts
and updates.



2. I do not want to use triggers as I can have severe performance issues



3. I would welcome any ready made tool available to do this.



4. As this deals with a transaction system, and the database size is
large, the replication method should have minimum issues related to
record locking, performance etc.



Thanks

Anant


--
Posted via http://dbforums.com

[Daniel Morgan]

akelkar wrote:
HeyIf any one can help me on data replication on Oracle 8i DB. Precisley Iwant to do :1. Replicate the data from one set of tables to another set of tables in a seperate DB instance. The replication should only work for inserts and updates. That is it should only replicate the data for inserts and updates.2. I do not want to use triggers as I can have severe performance issues3. I would welcome any ready made tool available to do this.4. As this deals with a transaction system, and the database size is large, the replication method should have minimum issues related to record locking, performance etc.ThanksAnant--Posted via http://dbforums.com
Please repost your request at c.d.o.server. This has nothing to do with
Tools.

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[Richard]

I think there is a graphical tool in Oracle 8 called Replication Manager or
something similar. It simplifies the creation of a replication environment
between two instances.

Best wishes,

Richard

"akelkar" <member45055@dbforums.com> wrote in message
news:3505605.1066744245@dbforums.com... Hey If any one can help me on data replication on Oracle 8i DB. Precisley I want to do : 1. Replicate the data from one set of tables to another set of tables in a seperate DB instance. The replication should only work for inserts and updates. That is it should only replicate the data for inserts and updates. 2. I do not want to use triggers as I can have severe performance issues 3. I would welcome any ready made tool available to do this. 4. As this deals with a transaction system, and the database size is large, the replication method should have minimum issues related to record locking, performance etc. Thanks Anant -- Posted via http://dbforums.com