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
mallinlr
Messages: 1
Registered: February 2009
Junior Member
Hi,

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.

Thanks
mmn

Report message to a moderator

Re: Best method to achieve [message #386996 is a reply to message #386294] Tue, 17 February 2009 09:20 Go to previous message
varunvir
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.
Regards,
Varun Punj,

Report message to a moderator

Previous Topic: Message posting via JMS queue in Oracle 11i ?
Next Topic: Performance issues when using AQ notification with one consumer
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 07 05:29:21 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.