Oracle DBMS_STREAMS_SM
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 CURRENT_USER
Dependencies
 DBA_APPLY DBMS_CAPTURE_ADM_IVK DBMS_SYS_ERROR
DBA_CAPTURE DBMS_LOB DBMS_UTILITY
DBA_CAPTURE_PARAMETERS DBMS_LOCK GLOBAL_NAME
DBA_PROPAGATION DBMS_LOGREP_UTIL GV$BUFFERED_SUBSCRIBERS
DBA_QUEUES DBMS_RECOVERABLE_SCRIPT GV$PROPAGATION_RECEIVER
DBA_QUEUE_TABLES DBMS_SCHEDULER STREAMS$_APPLY_PROCESS
DBA_RECOVERABLE_SCRIPT DBMS_SERVER_ALERT STREAMS$_CAPTURE_PROCESS
DBA_RECOVERABLE_SCRIPT_PARAMS DBMS_SERVER_ALERT_PRVT STREAMS$_CAPTURE_SERVER
DBA_SCHEDULER_JOBS DBMS_STANDARD STREAMS$_PROCESS_PARAMS
DBA_SCHEDULER_SCHEDULES DBMS_STREAMS_ADM STREAMS$_SPLIT_MERGE
DBA_USERS DBMS_STREAMS_ADM_IVK UTL_FILE
DBMS_APPLY_ADM DBMS_STREAMS_ADM_UTL _DBA_GGXSTREAM_OUTBOUND
DBMS_ASSERT DBMS_STREAMS_AUTO_INT _GV$SXGG_CAPTURE
DBMS_CAPTURE_ADM_INTERNAL DBMS_SYSTEM  
Documented No
First Available Not known
Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role.
Source {ORACLE_HOME}/rdbms/admin/prvthssm.plb
{ORACLE_HOME}/rdbms/admin/prvtbssm.plb
Subprograms
 
APPLY_EXISTS
Undocumented dbms_streams_sm.apply_exists(canon_apply_name IN VARCHAR2) RETURN BOOLEAN;
TBD
 
CAPTURE_SPLITTABLE
Undocumented dbms_streams_sm.capture_splittable(
canon_capture_name IN VARCHAR2,
raise_error        IN BOOLEAN)
RETURN BOOLEAN;
TBD
 
IS_UNCOMMITTED_XOUT
Undocumented dbms_streams_sm.is_uncommitted_xout(canon_apply_name IN VARCHAR2) RETURN BOOLEAN;
TBD
 
MERGE_STREAMS
Undocumented dbms_streams_sm.merge_streams(
canon_capture_name        IN OUT VARCHAR2,
canon_cloned_capture_name IN OUT VARCHAR2,
canon_streams_name        IN OUT VARCHAR2,
canon_cloned_streams_name IN     VARCHAR2,
streams_type              IN     NUMBER,
canon_queue_owner         IN OUT VARCHAR2,
canon_queue_name          IN OUT VARCHAR2,
canon_cloned_queue_owner  IN OUT VARCHAR2,
canon_cloned_queue_name   IN OUT VARCHAR2,
autosplit                 IN     BOOLEAN,
perform_actions           IN     BOOLEAN,
canon_script_dirobj       IN     VARCHAR2,
script_name               IN     VARCHAR2);
TBD
 
MERGE_STREAMS_JOB
Undocumented dbms_streams_sm.merge_streams_job(
canon_capture_name         IN VARCHAR2,
canon_cloned_capture_name  IN VARCHAR2,
canon_streams_name         IN VARCHAR2,
canon_cloned_streams_name  IN VARCHAR2,
streams_type               N NUMBER,
canon_queue_name           IN VARCHAR2,
canon_queue_owner          IN VARCHAR2,
merge_threshold            IN NUMBER,
canon_merge_schedule_owner IN VARCHAR2,
canon_merge_schedule_name  IN VARCHAR2,
canon_merge_job_owner      IN VARCHAR2,
canon_merge_job_name       IN VARCHAR2,
autosplit                  IN BOOLEAN);
TBD
 
OUTPUT_BOOLEAN
Undocumented dbms_streams_sm.output_boolean(b IN BOOLEAN) RETURN VARCHAR2;
DECLARE
 retVal dbms_id;
BEGIN
  retVal := dbms_streams_sm.output_boolean(TRUE);
  dbms_output.put_line(retVal);
END;
/
TRUE

PL/SQL procedure successfully completed.
 
SET_JOB_NEXT_RUN
Undocumented dbms_streams_sm.set_job_next_run(
canon_job_name  IN VARCHAR2,
s_date          IN TIMESTAMP,
interval        IN VARCHAR2,
e_date          IN TIMESTAMP,
canon_job_owner IN VARCHAR2);
TBD
 
SPLIT_JOB_INFO
Undocumented dbms_streams_sm.split_job_info(
canon_capture_name IN  VARCHAR2,
canon_job_owner    OUT VARCHAR2,
canon_job_name     OUT VARCHAR2);
TBD
 
SPLIT_STREAMS
Undocumented dbms_streams_sm.split_streams(
canon_propagation_name        IN     VARCHAR2,
canon_cloned_propagation_name IN OUT VARCHAR2,
canon_cloned_queue_owner      IN OUT VARCHAR2,
canon_cloned_queue_name       IN OUT VARCHAR2,
canon_cloned_capture_name     IN OUT VARCHAR2,
perform_actions               IN     BOOLEAN,
canon_script_dirobj           IN     VARCHAR2,
script_name                   IN     VARCHAR2,
auto_merge_threshold          IN     NUMBER,
canon_merge_schedule_owner    IN OUT VARCHAR2,
1canon_merge_schedule_name    IN OUT VARCHAR2,
1canon_merge_job_owner        IN OUT VARCHAR2,
1canon_merge_job_name         IN OUT VARCHAR2);
TBD
 
SPLIT_STREAMS_INTERNAL
Undocumented dbms_streams_sm.split_streams_internal(
canon_streams_name          IN     VARCHAR2,
canon_cloned_streams_name   IN OUT VARCHAR2,
streams_type                IN     NUMBER,
canon_cloned_queue_owner    IN OUT VARCHAR2,
canon_cloned_queue_name     IN OUT VARCHAR2,
canon_capture_name          IN OUT VARCHAR2,
canon_cloned_capture_name   IN OUT VARCHAR2,
perform_actions             IN     BOOLEAN,
canon_script_dirobj         IN     VARCHAR2,
script_name                 IN     VARCHAR2,
auto_merge_threshold        IN     NUMBER,
canon_merge_schedule_owner  IN OUT VARCHAR2,
canon_merge_schedule_name   IN OUT VARCHAR2,
canon_merge_job_owner       IN OUT VARCHAR2,
canon_merge_job_name        IN OUT VARCHAR2,
autosplit                   IN     BOOLEAN);
TBD
 
TRY_DROP_JOB
Undocumented dbms_streams_sm.try_drop_job(
canon_job_name  IN VARCHAR2,
canon_job_owner IN VARCHAR2);
TBD
 
WRITE_ALERT
Undocumented dbms_streams_sm.write_alert(
canon_capture_name IN VARCHAR2,
msg                IN VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_STREAMS
DBMS_STREAMS_ADM
DBMS_STREAMS_ADM_UTIL_INT
DBMS_STREAMS_AUTH
DBMS_STREAMS_CONTROL_ADM
DBMS_STREAMS_HANDLER_ADM
DBMS_STREAMS_MC
DBMS_STREAMS_MC_INV
DBMS_STREAMS_MESSAGING
DBMS_STREAMS_PUB_RPC
DBMS_STREAMS_RPC_INTERNAL
DBMS_STREAMS_TABLESPACE_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