| 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'); |
