Replication [message #75289] |
Fri, 15 November 2002 16:17 |
Tom
Messages: 67 Registered: June 1998
|
Member |
|
|
Hi,
I am looking for an optimal solution from both a performance and cost perspective for the following requirement.
I have a small load OLTP system (oracle9i) each in 3 different countries.Each country has a local system of its own. The system in each country needs data from 5 tables belonging to the local system of the remaining two countries for read only purposes.
The network connection is going to be VPN based and data load is not that heavy.
I wish to know what would be the optimal solution in terms of
- Advanced replication
- Materialized views
- any other
I would sincerely appreciate your Inputs
Tom
|
|
|