Oracle | DBMS_PROPAGATION

Oracle DBMS_PROPAGATION_ADM Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Supports Streams Data Propagation

AUTHID CURRENT_USER

Dependencies (Updated to 12.2.0.1)

DBMS_LOGREP_IMP	DBMS_STANDARD	DBMS_STREAMS_ADM_UTL
DBMS_LOGREP_UTIL	DBMS_STREAMS_ADM_IVK	DBMS_UTILITY
DBMS_PROPAGATION_INTERNAL

Documented Yes: Packages and Types Reference

First Available 9.2

Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role

Source {ORACLE_HOME}/rdbms/admin/dbmsprp.sql

Subprograms

ALTER_PROPAGATION	DROP_PROPAGATION	STOP_PROPAGATION
CREATE_PROPAGATION	START_PROPAGATION

ALTER_PROPAGATION

Alters, or removes a rule set for a propagation dbms_propagation_adm.alter_propagation( propagation_name IN VARCHAR2, rule_set_name IN VARCHAR2 DEFAULT NULL, remove_rule_set IN BOOLEAN DEFAULT FALSE, negative_rule_set_name IN VARCHAR2 DEFAULT NULL, remove_negative_rule_set IN BOOLEAN DEFAULT FALSE);

TBD

CREATE_PROPAGATION

Creates a propagation and specifies the source queue, destination queue, and any rule set for the propagation. A propagation propagates messages in a local source queue to a destination queue. The destination queue might or might not be in the same database as the source queue. dbms_propagation_adm.create_propagation( propagation_name IN VARCHAR2, source_queue IN VARCHAR2, destination_queue IN VARCHAR2, destination_dblink IN VARCHAR2 DEFAULT NULL, rule_set_name IN VARCHAR2 DEFAULT NULL, negative_rule_set_name IN VARCHAR2 DEFAULT NULL, queue_to_queue IN BOOLEAN DEFAULT NULL, -- the following two parameters are ONLY used by the split-merge api original_propagation_name IN VARCHAR2 DEFAULT NULL, auto_merge_threshold IN NUMBER DEFAULT NULL);

TBD

DROP_PROPAGATION

Drops a propagation and deletes all captured and user-enqueued messages for the destination queue in the source queue. Also removes the schedule for propagation from the source to destination queue. dbms_propagation_adm.drop_propagation( propagation_name IN VARCHAR2, drop_unused_rule_sets IN BOOLEAN DEFAULT FALSE);

exec dbms__propagation_adm.drop_propagation('UWDEMOPROP', TRUE);

START_PROPAGATION

Starts a propagation dbms_propagation_adm.start_propagation(propagation_name IN VARCHAR2);

exec dbms__propagation_adm.start_propagation('UWDEMOPROP');

STOP_PROPAGATION

Stops a propagation dbms_propagation_adm.stop_propagation( propagation_name IN VARCHAR2, force IN BOOLEAN DEFAULT FALSE);

SELECT propagation_name

      FROM dba_propagation;

      

      exec dbms__propagation_adm.stop_propagation('UWDEMOPROP');