73
DBMS_STREAMS_ADM

The DBMS_STREAMS_ADM package provides administrative procedures for adding and removing simple rules, without transformations, for capture, propagation, and apply at the table, schema, and database level. These rules support logical change records (LCRs), which include row LCRs and data definition language (DDL) LCRs. This package also contains procedures for creating queues and for managing Streams metadata, such as data dictionary information.

This chapter contains the following topic:

• Summary of DBMS_STREAMS_ADM Subprograms

If you require more sophisticated rules or rules involving non-LCR events, then you can use the DBMS_RULE_ADM package.

If you require transformations on simple rules, then you can use the DBMS_RULE_ADM package to add, update, or remove transformations on rules created by the DBMS_STREAMS_ADM package.