Home » Server Options » Replication » oracle table replication  () 1 Vote
oracle table replication [message #126235] Fri, 01 July 2005 15:12 Go to next message
moe_w90
Messages: 8
Registered: March 2005
Location: USA
Junior Member
Hi,
For the ones who saw this topic in EM section, sorry about that.
posted it by mistake Smile.
I have three copies of 150 tables. Each copy (150 table resides on a database). I want to do synchronization between the three so that if data is written to a table on any of the three databases, it gets replicated to the other two. I know that i can use materialized views but with materialized view i have a real table and a view where data gets replicated to so it's one way synchronization. What is the fastest and best to accomplish that.?

Thanks in advance

Moe

Report message to a moderator

Re: oracle table replication [message #126424 is a reply to message #126235] Mon, 04 July 2005 07:45 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
hey

nice question dude, i m also interested in the answer

Report message to a moderator

Re: oracle table replication [message #137340 is a reply to message #126235] Wed, 14 September 2005 13:48 Go to previous message
renanmed
Messages: 1
Registered: September 2005
Location: Brazil
Junior Member
I hava a replication software(SQL@Replicator).
I don´t use MV. I user base tables.
The software is too easy to setup.
The replication is assync e must be configured(job) by user.

Report message to a moderator

Previous Topic: database replication
Next Topic: ora-04020: deadlock detected while trying to lock objext XX.MLOG$_YY_@MyDBLINK.US.ORACLE.COM
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 06 00:39:02 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.