Oracle 12c DBMS_PROPAGATION

Oracle DBMS_PROPAGATION_ADM Version 12.1.0.2

General Information

Library Note

Morgan's Library Page Footer

The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,

Purpose

Supports Streams and Change Data Capture Propagation

AUTHID

CURRENT_USER

Dependencies

DBMS_LOGREP_IMP	DBMS_REPCAT_DECL	DBMS_STREAMS_ADM_UTL
DBMS_PROPAGATION_INTERNAL	DBMS_STANDARD	DBMS_UTILITY
DBMS_REPCAT_COMMON_UTL	DBMS_STREAMS_ADM_IVK

Documented

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	DROP_PROPAGATION	STOP_PROPAGATION
CREATE_PROPAGATION	START_PROPAGATION

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