Home » Server Options » Replication » Replication in 10G without DB links. (Oracle 10G Enterprise edition)
Replication in 10G without DB links. [message #457416] Mon, 24 May 2010 06:22 Go to next message
Messages: 19
Registered: August 2008
Junior Member
We have two databases A and B, both are 10g Enterprise edition and we have to replicate only one table from A to B. A is the source and B needs a read only copy. The source of A is modified by User through Oracle Forms. A latency of 1day can be accepted though the lesser the better.
The problem is that this company does not approve of DB links in any form or any tool which in the end has to create a DB link(dont ask me why).
Is there any way this replication can be achieved?

Re: Replication in 10G without DB links. [message #457445 is a reply to message #457416] Mon, 24 May 2010 08:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use export/import or DataPump.

Re: Replication in 10G without DB links. [message #460368 is a reply to message #457416] Thu, 10 June 2010 15:08 Go to previous message
Messages: 9
Registered: June 2010
Location: Canada
Junior Member
Please try our product for database replication - you can setup real-time replication between your 2 Oracle databases , all changes from table A will be automatically replicated and applied to table B to meet your requirements.

No DB links, no any other modifications within your source schema (no triggers).



Previous Topic: Materialized view query
Next Topic: Doubt in Replicating Data from DB to another
Goto Forum:

Current Time: Sun Apr 02 06:14:08 CDT 2023