Oracle in a Nutshell

Calls

PROCEDURE DBMS_STREAM_ADM.ADD_GLOBAL_PROPAGATION_RULES (streams_name IN VARCHAR2, source_queue_name IN VARCHAR2, destination_queue_name IN VARCHAR2, include_dml IN BOOLEAN DEFAULT TRUE, include_ddl IN BOOLEAN DEFAULT FALSE, include_lcr IN BOOLEAN DEFAULT FALSE, source_database IN VARCHAR2 DEFAULT NULL, dml_rule_name OUT VARCHAR2, ddl_rule_name OUT VARCHAR2);

Adds a rule to a propagation job streams_name that propagates all the logical change records (LCRs) in a source_queue_name from source_database to destination_queue_name. If include_dml, returns dml_rule_name. If include_ddl, returns ddl_rule_name. If include_lcr, a logical change record is always considered for propagation.

PROCEDURE DBMS_STREAM_ADM.ADD_GLOBAL_RULES (streams_name IN VARCHAR2, streams_type IN VARCHAR2 DEFAULT NULL, queue_name IN VARCHAR2 DEFAULT 'STREAMS_QUEUE', include_dml IN BOOLEAN DEFAULT TRUE, include_ddl IN BOOLEAN DEFAULT FALSE, include_lcr IN BOOLEAN DEFAULT FALSE, source_database IN VARCHAR2 DEFAULT NULL, dml_rule_name OUT VARCHAR2, ddl_rule_name OUT VARCHAR2);

Adds a rule to streams_name of streams_type (CAPTURE or APPLY) for all the LCRs in queue_name from source_database. (For capture rules, queue_name enqueues the changes; for apply rules, the changes are dequeued from queue_name.) If include_dml, returns dml_rule_name. If include_ddl, returns ddl_rule_name. If include_lcr, an LCR is always considered for propagation.

PROCEDURE DBMS_STREAM_ADM.ADD_SCHEMA_PROPAGATION_RULES (schema_name IN ...