Oracle 12cR2 DBMS_PROPAGATION

Oracle DBMS_PROPAGATION_ADM Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"

~ Sen. Tammy Duckworth

Purpose Supports Streams and Change Data Capture 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 No

First Available 9.2.0.1

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