Oracle Streams-Different domain

[user1979]

Hi,

Can Oracle Streams be used to sync two databases which are in different domains ?


TIA,

-Amol

[adewri]

What is your definition of different domains. If by domains you mean different RDBMS then yes they can be brought in sync provided that the other DB understands Messaging and Queuing.

[user1979]

Hi ,

Thanks for your reply.

Let me explain what I want.

I want to sync two oracle databases .
Both these databases are running on different machines and are located at different location.

Both the machines are connected to the internet.

Can I sync these two databases ?

Please let me know.

-Amol

[adewri]

Yes it is very much possible.

Read this.

http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96571/toc.htm

[adewri]

But i would suggest you to try replication instead if its just sync of data and nothing else. Streams is some what complicated and is based on technologies like, Adavanced Queuing, Replication, Logminer etc.

[user1979]

Hi adewri,

Thanks a lot for the reply.

-Amol