Oracle | DBMS_STREAMS

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	MERGE_STREAMS_JOB	SPLIT_STREAMS
CAPTURE_SPLITTABLE	OUTPUT_BOOLEAN	SPLIT_STREAMS_INTERNAL
IS_UNCOMMITTED_XOUT	SET_JOB_NEXT_RUN	TRY_DROP_JOB
MERGE_STREAMS	SPLIT_JOB_INFO	WRITE_ALERT

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