Home » Server Options » Replication » Oracle multimaster replication agents
Oracle multimaster replication agents [message #75157] Mon, 08 April 2002 00:11 Go to next message
Vishwanath
Messages: 4
Registered: April 2002
Junior Member
Hi all,
I have a requirment, wherein I hava a Oracle tables, on the other machines I have a different database with the sames tables as in Oracle database. I want these two tables to be in sync. Is there any tools aviable for this. If yes URL please.

Thanks in advance
Vishwanath
Re: Oracle multimaster replication agents [message #75158 is a reply to message #75157] Mon, 08 April 2002 01:44 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

You can replicate the tables between your databases. Replication is the process of creating and maintaining replica versions of database objects (e.g. tables) in a distributed database system.

See the Oracle Replication FAQ at http://www.orafaq.org/faqrepl.htm.

Best regards.

Frank
Re: Oracle multimaster replication agents [message #75160 is a reply to message #75157] Mon, 08 April 2002 02:54 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

Oracle replication only works between Oracle databases. Other vendors may provide replication solutions for heterogeneous database environments. One such vendor that comes to mind is Sybase. Please contact them for more information.

Best rergards

Frank
Re: Oracle multimaster replication agents [message #75183 is a reply to message #75157] Fri, 24 May 2002 16:06 Go to previous message
David Simpson
Messages: 29
Registered: May 2002
Junior Member
You might want to look at the sample scripts on my web site. These were created with my Repgen application:
http://www.dotcomsolutionsinc.net/products/repgen/repgen_files.html

Or you may download a demo version and look at the sample scripts on your own computer:
http://www.dotcomsolutionsinc.net/downloads/demo_software/index.html

One of the critical aspects of Advanced Replication which is automatically handled by the scripts created by Repgen is the setup of conflict resolution. An incorrect setup of the conflict resolution parameters will cause data divergence between the replicated systems - which is not desirable.
http://www.dotcomsolutionsinc.net/products/repgen/repgen_features_benefits.html

Previous Topic: 806 <-> 817 replication
Next Topic: Linking databases
Goto Forum:
  


Current Time: Fri Mar 29 04:44:21 CDT 2024