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

Related Topics
Advanced Queuing
Built-in Functions
Built-in Packages
DBMS_CAPTURE_ADM
DBMS_CDC_PUBLISH
DBMS_CDC_SUBSCRIBE
DBMS_STREAMS
DBMS_STREAMS_ADM
DBMS_STREAMS_AUTH
DBMS_STREAMS_MC
Packages
Streams Demo 1
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved