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
vikram_contact
Messages: 19
Registered: August 2008
Junior Member
Hi,
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?

Regards,
Vikram
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: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use export/import or DataPump.

Regards
Michel
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
sovekconsulting
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).

www.sovek-consulting.com/index.php/products/data-replication

Regards,

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


Current Time: Thu Mar 28 23:52:32 CDT 2024