Oracle | DBMS_PROPAGATION

Oracle DBMS_PROPAGATION_INTERNAL Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Undocumented

AUTHID DEFINER

Dependencies

AQ$_AGENT	DBMS_PROPAGATION_ADM	DBMS_SYS_ERROR
DBA_PROPAGATION	DBMS_SERVER_ALERT	DUAL
DBA_QUEUE_SCHEDULES	DBMS_SERVER_ALERT_PRVT	OBJ$
DBMS_AQADM	DBMS_STANDARD	STREAMS$_CAPTURE_SERVER
DBMS_AQADM_INV	DBMS_STREAMS_ADM_IVK	STREAMS$_PROPAGATION_PROCESS
DBMS_AQADM_SYS	DBMS_STREAMS_ADM_UTL	STREAMS$_PROPAGATION_SEQNUM
DBMS_LOGREP_UTIL	DBMS_STREAMS_AUTO_INT	WRI$_ALERT_OUTSTANDING
DBMS_LOGREP_UTIL_INVOK

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvthprp.plb

Subprograms

ALTER_PROPAGATION	DROP_PROPAGATION	START_PROPAGATION
CLEAR_PROP_ABORT_ALERT	RAISE_PROP_ABORTED_ALERT_JOBID	STOP_PROPAGATION
CREATE_PROPAGATION

ALTER_PROPAGATION

Alters a propagation dbms_propagation_internal.alter_propagation( propagation_name IN VARCHAR2, rule_set_name IN VARCHAR2, remove_rule_set IN BOOLEAN, negative_rule_set_name IN VARCHAR2, remove_negative_rule_set IN BOOLEAN, canon_invoker IN VARCHAR2);

TBD

CLEAR_PROP_ABORT_ALERT

Clears a propagation abort alert message dbms_propagation_internal.clear_prop_abort_alert( canon_full_squeue IN VARCHAR2, canon_full_dqueue IN VARCHAR2, canon_dblink IN VARCHAR2, canon_prop_name IN VARCHAR2);

TBD

CREATE_PROPAGATION

Creates a propagation dbms_propagation_internal.create_propagation( propagation_name IN VARCHAR2, source_queue IN VARCHAR2, destination_queue IN VARCHAR2, destination_dblink IN VARCHAR2, canon_invoker IN VARCHAR2, rule_set_name IN VARCHAR2, negative_rule_set_name IN VARCHAR2, queue_to_queue IN BOOLEAN, original_propagation_name IN VARCHAR2, auto_merge_threshold IN NUMBER);

TBD

DROP_PROPAGATION

Drops a propagation

Overload 1 dbms_propagation_internal.drop_propagation( propagation_name IN VARCHAR2, drop_unused_rule_setS IN BOOLEAN, canon_invoker IN VARCHAR2);

TBD

Overload 2 dbms_propagation_internal.drop_propagation( propagation_name IN VARCHAR2, canon_invoker IN VARCHAR2);

TBD

RAISE_PROP_ABORTED_ALERT_JOBID

Undocumented dbms_propagation_internal.raise_prop_aborted_alert_jobid(jobid IN NUMBER);

TBD

START_PROPAGATION

Undocumented dbms_propagation_internal.start_propagation( propagation_name IN VARCHAR2, canon_invoker IN VARCHAR2);

TBD

STOP_PROPAGATION

Undocumented dbms_propagation_internal.stop_propagation( propagation_name IN VARCHAR2, force IN BOOLEAN, canon_invoker IN VARCHAR2);

TBD