Home » Server Options » Streams & AQ » synchronizing databases on windows and linux
synchronizing databases on windows and linux [message #266358] Mon, 10 September 2007 11:33 Go to next message
nileshkum@gmail.com
Messages: 1
Registered: August 2007
Location: india
Junior Member

i am designing an application in which i have a replicated databases on the windows and linux.i will be updating the data in the database using the front end. If i enter the data in the database which is on the linux then the changes need to be reflected on the database which is on the windows platform, So that the both the database are been synchronized.Could any one help me how shall i proceed.
Re: synchronizing databases on windows and linux [message #266381 is a reply to message #266358] Mon, 10 September 2007 12:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This can't be done with Streams.
Use materialized views.

Regards
Michel
Re: synchronizing databases on windows and linux [message #266419 is a reply to message #266381] Mon, 10 September 2007 17:29 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Michel Cadot wrote on Mon, 10 September 2007 13:25
This can't be done with Streams.


Streams can actually do this.
Re: synchronizing databases on windows and linux [message #266430 is a reply to message #266358] Mon, 10 September 2007 21:51 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Yes, Michel Stream can do.
Re: synchronizing databases on windows and linux [message #266454 is a reply to message #266430] Mon, 10 September 2007 23:33 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oh yes! Was stuck on 9i limitations.

Regards
Michel
Previous Topic: How to send Oracle AQ to ESB using Message Gateway
Next Topic: Streams only for insert statement
Goto Forum:
  


Current Time: Fri Mar 29 03:57:28 CDT 2024