O'Reilly logo

Oracle 11g Streams Implementer's Guide by Eric Yen, Ann L. R. McKinnell

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

Subsetting — the micro side of replication

In the previous chapters, we looked at replicating whole table via table level and schema level replication. There may be times when you only what to replicate a subset of rows in a table to a site. Say for instance, your corporate headquarter's database has HR table data for all departments, but you only want to send HR data specific to location_id to that location's database. You can do this with subsetting rules. Subsetting is considered a table level replication, but includes a filter parameter that is applied to the process to include only those LCRs that meet that filter criteria. Along with the ADD GLOBAL, SCHEMA, and TABLE rules of the DBMS_STREAMS_ADM package, the ADD_SUBSET_RULE can be defined ...

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