Home » Server Options » Replication » oracle table replication  () 1 Vote
oracle table replication [message #126235] Fri, 01 July 2005 15:12 Go to next message
Messages: 8
Registered: March 2005
Location: USA
Junior Member
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

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
Messages: 1080
Registered: June 2005
Location: India
Senior Member

nice question dude, i m also interested in the answer
Re: oracle table replication [message #137340 is a reply to message #126235] Wed, 14 September 2005 13:48 Go to previous message
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.
Previous Topic: database replication
Next Topic: ora-04020: deadlock detected while trying to lock objext XX.MLOG$_YY_@MyDBLINK.US.ORACLE.COM
Goto Forum:

Current Time: Sat Nov 27 00:23:55 CST 2021