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
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_PROPAGATION_ADM
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx