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 ...