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 is now availble. If you haven't you downloaded already: Why?

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');