Oracle 12cR2 DBMS_XSTREAM_UTL

Oracle DBMS_XSTREAM_UTL_IVK Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.

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.0.3

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