Replication in 10G without DB links. [message #457416] |
Mon, 24 May 2010 06:22 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #460368 is a reply to message #457416] |
Thu, 10 June 2010 15:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
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,
|
|
|