Oracle DBMS_PROPAGATION_ADM
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.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.
Purpose Supports Streams and Change Data Capture Propagation
AUTHID CURRENT_USER
Dependencies
DBMS_LOGREP_IMP DBMS_REPCAT_DECL DBMS_STREAMS_ADM_UTL
DBMS_PROPAGATION_INTERNAL DBMS_STREAMS_ADM_IVK DBMS_UTILITY
DBMS_REPCAT_COMMON_UTL    
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
DBMS_CAPTURE_ADM
DBMS_CDC_PUBLISH
DBMS_CDC_SUBSCRIBE
DBMS_STREAMS
DBMS_STREAMS_ADM
DBMS_STREAMS_AUTH
DBMS_STREAMS_MC
Packages
Streams Demo 1

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-2014 Daniel A. Morgan All Rights Reserved