Oracle | DBMS_PROPAGATION

Oracle DBMS_PROPAGATION_ADM Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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');