| General Information |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsprp.sql |
| First Available |
9.2 |
| Dependencies |
| DBMS_LOGREP_IMP |
DBMS_STREAMS_ADM |
| DBMS_PROPAGATION_INTERNAL |
DBMS_STREAMS_ADM_UTL |
| DBMS_REPCAT_COMMON_UTL |
DBMS_UTILITY |
| DBMS_REPCAT_DECL |
|
|
| Security Model |
Execute is granted to the EXECUTE_CATALOG_ROLE role |
| 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 (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 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'); |
