Oracle DBMS_PROPAGATION_ADM
Version 19.2.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
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
Streams Demo 1
What's New In 18cR3
What's New In 19cR2

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