Oracle | DBMS_XSTREAM_UTL

Oracle DBMS_XSTREAM_UTL_IVK 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 XStreams Support Utilities

AUTHID CURRENT_USER

Dependencies

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

Documented No

First Available 11.2

Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_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_OUTBOUND

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

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