Oracle 12c DBMS_PROPAGATION

Oracle DBMS_PROPAGATION_ADM Version 12.1.0.2

General Information

Library Note

Morgan's Library Page Header

The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.

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