O'Reilly logo

Applying and Extending Oracle Spatial by Siva Ravada, Simon Gerard Greener

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Streams based replication

Oracle provides two basic technologies for general replication between two or more Oracle databases, namely, advanced replication and streams based replication. The streams based replication provides a more efficient solution than the one based on advanced replication. Rather than synchronously capturing changes in the materialized view logs, which adds overhead to the transaction, streams mine the redo logs created by the updates to the database and create change logs to send to the target database system. This architecture also allows the change to be replicated to more than one system much more quickly. The advanced replication also has some restrictions with SDO_GEOMETRY types that are harder to work around.

In this ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required