Realtime data transfer between two or more Oracle databases.

Question

Hi,

I'm not a techie as such but have a question which I would like some views on. Currently we have 4 applications runnings on either Oracle 10g or 9i and use OAQ for data transfer but Oracle Streams for within day data transfer. Streams is currently viewed as bringing tight coupling between the applications and such will not be our method of choice going forward.
What I would like to know is a: is the assumption about streams correct and b: what other methods or tools should be considered to replace this functionality.

Many thanks.

Answer 1

Streams is currently viewed as bringing tight coupling between the applications

I would disagree with this statement. Streams is a mechanism of replicating data, the same data can be used in various ways by different applications. Can you elaborate more why you reached this conclusion.

An alternative to Streams is Oracle MView Replication or Advanced Replication, but nowadays Streams is the de facto standard as it does not require direct DB-to-DB links, i.e. it can run over HTTP. If some of the applications are read-only, you could also consider Active Data Guard (which again uses Streams for replication).

Answer 2

Have a look at the Oracle distributed Database capabilities