Oracle | DBMS_STREAMS

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