December 2002
Intermediate to advanced
928 pages
85h 29m
English
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 ...