Oracle | DBMS_XSTREAM_UTL

Oracle DBMS_XSTREAM_UTL_IVK Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose XStreams Support Utilities

AUTHID CURRENT_USER

Dependencies

ALL_CAPTURE	DBMS_STANDARD
ALL_XSTREAM_OUTBOUND	DBMS_STREAMS_ADM
DBA_APPLY	DBMS_STREAMS_ADM_IVK
DBA_CAPTURE	DBMS_STREAMS_ADM_UTL
DBA_REGISTERED_ARCHIVED_LOG	DBMS_STREAMS_ADM_UTL_INVOK
DBMS_APPLY_ADM	DBMS_STREAMS_DECL
DBMS_APPLY_ADM_INTERNAL	DBMS_STREAMS_RPC
DBMS_ASSERT	DBMS_UTILITY
DBMS_CAPTURE_ADM	DBMS_XSTREAM_ADM
DBMS_CAPTURE_ADM_INTERNAL	DBMS_XSTREAM_ADM_INTERNAL
DBMS_FLASHBACK	DBMS_XSTREAM_ADM_UTL
DBMS_GSM_DBADMIN	DBMS_XSTREAM_GG_ADM
DBMS_LOCK	DBMS_XSTREAM_GG_INTERNAL
DBMS_LOGREP_UTIL	GLOBAL_NAME
DBMS_LOGREP_UTIL_INVOK	GV$ARCHIVED_LOG
DBMS_RULE_ADM	PLITBLM
DBMS_SHARED_CAPTURE_ADM	TIMESTAMP_TO_SCN

Documented No

First Available 11.2

Security Model Owned by SYS with EXECUTE granted to GSMADMIN_INTERNAL and the EXECUTE_CATALOG_ROLE role.

Source {ORACLE_HOME}/rdbms/admin/prvthxstr.plb

Subprograms

ADD_OUTBOUND	COMMA_TO_TABLE_INT	DROP_INBOUND
ADD_SUBSET_OUTBOUND_RULES	CREATE_INBOUND	STR_LENGTH_CK
ALTER_INBOUND	CREATE_OUTBOUND	VALIDATE_SRCDB_INPUT
ALTER_OUTBOUND

ADD_OUTBOUND

Add an outbound server process

Overload 1 dbms_xstream_utl_ivk.add_outbound( server_name IN VARCHAR2, queue_name IN VARCHAR2, source_database IN VARCHAR2, table_names IN dbms_utility.uncl_array, schema_names IN dbms_utility.uncl_array, connect_user IN VARCHAR2, comment IN VARCHAR2, committed_data_only IN BOOLEAN, capture_name IN VARCHAR2, start_scn IN NUMBER, start_time IN TIMESTAMP, include_dml IN BOOLEAN, include_ddl IN BOOLEAN, source_root_name IN VARCHAR2, lcrid_version IN NUMBER);

TBD

Overload 2 dbms_xstream_utl_ivk.add_outbound( server_name IN VARCHAR2, queue_name IN VARCHAR2, source_database IN VARCHAR2, table_names IN VARCHAR2, schema_names IN VARCHAR2, connect_user IN VARCHAR2, comment IN VARCHAR2, committed_data_only IN BOOLEAN, capture_name IN VARCHAR2, start_scn IN NUMBER, start_time IN TIMESTAMP, include_dml IN BOOLEAN, include_ddl IN BOOLEAN, source_root_name IN VARCHAR2, lcrid_version IN NUMBER);

TBD

ADD_SUBSET_OUTBOUND_RULES

Undocumented

Overload 1 dbms_xstream_utl_ivk.add_subset_outbound_rules( server_name IN VARCHAR2, table_name IN VARCHAR2, condition IN VARCHAR2, column_list IN dbms_utility.lname_array, keep IN BOOLEAN, source_database IN VARCHAR2, source_root_name IN VARCHAR2);

TBD

Overload 2 dbms_xstream_utl_ivk.add_subset_outbound_rules( server_name IN VARCHAR2, table_name IN VARCHAR2, condition IN VARCHAR2, column_list IN VARCHAR2, keep IN BOOLEAN, source_database IN VARCHAR2, source_root_name IN VARCHAR2);

TBD

ALTER_INBOUND

Alter an inbound server process dbms_xstream_utl_ivk.alter_inbound( server_name IN VARCHAR2, apply_user IN VARCHAR2, comment IN VARCHAR2);

exec dbms_xstream_utl_ivk.alter_inbound('ZZYZX', USER, 'Alter ZZYZX In');

Alter an outbound server process

Overload 1 dbms_xstream_utl_ivk.alter_outbound( server_name IN VARCHAR2, table_names IN dbms_utility.uncl_array, schema_names IN dbms_utility.uncl_array, add IN BOOLEAN, capture_user IN VARCHAR2, connect_user IN VARCHAR2, comment IN VARCHAR2, inclusion_rule IN BOOLEAN, start_scn IN NUMBER, start_time IN TIMESTAMP, include_dml IN BOOLEAN, include_ddl IN BOOLEAN, source_database IN VARCHAR2);

TBD

Overload 2 dbms_xstream_utl_ivk.alter_outbound( server_name IN VARCHAR2, table_names IN VARCHAR2, schema_names IN VARCHAR2, add IN BOOLEAN, capture_user IN VARCHAR2, connect_user IN VARCHAR2, comment IN VARCHAR2, inclusion_rule IN BOOLEAN, start_scn IN NUMBER, start_time IN TIMESTAMP, include_dml IN BOOLEAN, include_ddl IN BOOLEAN, source_database IN VARCHAR2);

TBD

Overload 3 dbms_xstream_utl_ivk.alter_outbound( server_name IN VARCHAR2, oldest_scn IN BINARY_INTEGER, processed_lwm_scn IN BINARY_INTEGER, flags IN BINARY_INTEGER);

TBD

COMMA_TO_TABLE_INT

Undocumented dbms_xstream_utl_ivk.comma_to_table_int( namelist IN VARCHAR2, tablen OUT NUMBER, nametab OUT dbms_utility.uncl_array, allow_3X_iden IN BOOLEAN);

TBD

CREATE_INBOUND

Create the inbound server process dbms_xstream_utl_ivk.create_inbound( server_name IN VARCHAR2, queue_name IN VARCHAR2, apply_user IN VARCHAR2, comment IN VARCHAR2, committed_data_only IN BOOLEAN, scn_based_position IN BOOLEAN);

exec dbms_xstream_utl_ivk.create_inbound('ZZYZX', 'ZZYZX_Q', USER, 'Create ZZYZX In', TRUE, TRUE);

CREATE_OUTBOUND

Create the outbound server process

Overload 1 dbms_xstream_utl_ivk.create_outbound( server_name IN VARCHAR2, source_database IN VARCHAR2, table_names IN dbms_utility.uncl_array, schema_names IN dbms_utility.uncl_array, capture_user IN VARCHAR2, connect_user IN VARCHAR2, comment IN VARCHAR2, committed_data_only IN BOOLEAN, capture_name IN VARCHAR2 include_dml IN BOOLEAN, include_ddl IN BOOLEAN, enable_procedure IN BOOLEAN, source_root_name IN VARCHAR2 lcrid_version IN NUMBER);

TBD

Overload 2 dbms_xstream_utl_ivk.create_outbound( server_name IN VARCHAR2, source_database IN VARCHAR2, table_names IN VARCHAR2, schema_names IN VARCHAR2, capture_user IN VARCHAR2, connect_user IN VARCHAR2, comment IN VARCHAR2, committed_data_only IN BOOLEAN, capture_name IN VARCHAR2, include_dml IN BOOLEAN, include_ddl IN BOOLEAN, enable_procedure IN BOOLEAN, source_root_name IN VARCHAR2, lcrid_version IN NUMBER);

TBD

DROP_INBOUND

Drop the inbound server process dbms_xstream_utl_ivk.drop_inbound(server_name IN VARCHAR2);

exec dbms_xstream_utl_ivk.drop_inbound('ZZYZX');

STR_LENGTH_CK

Undocumented dbms_xstream_utl_ivk.sr_length_ck( str IN VARCHAR2, maxlen IN NUMBER, argname IN VARCHAR2);

TBD

VALIDATE_SRCDB_INPUT

Undocumented dbms_xstream_utl_ivk.validate_srcdb_input(source_db IN VARCHAR2);

exec dbms_xstream_utl_ivk.validate_srcdb_input('PRODHR');