Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page