Capture Creation – Using add_global_rules procedure

The global Capture process captures changes from all of the schema objects: however, it does not capture changes made in the SYS, SYSTEM, or CTXSYS schemas. This procedure would be used for maintaining a total copy of the database at a remote site.

The add_global_rules procedure creates two rules: one for row LCRs containing the results of DML changes and another one for DDL LCRs.

Below is the rule condition used by the row LCR rule:

(:dml.is_null_tag() = 'Y' )

Below is the rule condition used by the DDL LCR rule:

(:ddl.is_null_tag() = 'Y' )

The following SQL block shows the signature of the add_global_rules procedure:

DBMS_STREAMS_ADM.ADD_GLOBAL_RULES(
 Streams_type             IN VARCHAR2,
 Streams_name                         IN VARCHAR2 DEFAULT NULL,
 queue_name                IN VARCHAR2 DEFAULT 'Streams_queue',
 include_dml                 IN BOOLEAN DEFAULT true,