$page_title = $titlebar_text; $header_bar_text = $titlebar_text; ///////////////////////////////////// // get header include('rlib_header.php'); // print << 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
  EOM; ///////////////////////////////////// // get footer include('rlib_footer.php'); ?>