CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_PROPAGATION_ADM
Version 11.1
 
General Information
Source {ORACLE_HOME}/rdbms/admin/dbmsprp.sql
First Available 9.2
Dependencies
DBMS_LOGREP_IMP DBMS_REPCAT_DECL
DBMS_PROPAGATION_INTERNAL DBMS_STREAMS_ADM
DBMS_REPCAT_COMMON_UTL DBMS_STREAMS_ADM_UTL
Security Model Execute is granted to the EXECUTE_CATALOG_ROLE role
 
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 (new 11g parameters)

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 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
Streams Demo
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [56 users online]    © 2010 psoug.org