Home » Server Options » Streams & AQ » Best method to achieve (Oracle 10g)
Best method to achieve [message #386294] Fri, 13 February 2009 08:15 Go to next message
Messages: 1
Registered: February 2009
Junior Member

Please suggest me the right architecture in Oracle 10g to achieve the following scenario.

We have 300+ sites with local Oracle 10g DBs all are connected with the Main DB Server 10g.
The Each site has its specific data and Main Server has all sites data. (Ex: Product price and taxes are different at each location)
Main Server DB and Local DBs has the same DB schema.
We want to synchronize data between site DBs and main server DB with bi-directional way.

Which Technology is better to achieve data synchronization in Oracle 10g.

Re: Best method to achieve [message #386996 is a reply to message #386294] Tue, 17 February 2009 09:20 Go to previous message
Messages: 389
Registered: November 2007
Senior Member
Oracle Streaming will be good approach to acheive this.
Please go throught the Stream documentation to configure it.
Varun Punj,
Previous Topic: Message posting via JMS queue in Oracle 11i ?
Next Topic: Performance issues when using AQ notification with one consumer
Goto Forum:

Current Time: Sun Dec 10 20:14:01 CST 2023