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

Replicating data with materialized views

Materialized view based replication is very useful when the changes at the master site do not have to be immediately available at the secondary sites. This is also useful when the connectivity between the master and slave sites is not continuous. When only a subset of tables or portions of the tables are required at the secondary sites in an asynchronous fashion, materialized view based replication is one of the most common ways to achieve it.

As we discussed in the previous chapter, a materialized view is a replica of a table that can be refreshed at regular intervals or on demand. During a refresh, only the final values of the changed rows are pulled down, no matter how many updates were applied to the ...

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