Oracle | DBMS_PROPAGATION

Oracle DBMS_PROPAGATION_INTERNAL Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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