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

Related Topics
Built-in Functions
Built-in Packages
DBMS_UTILITY
DBMS_XSTREAM_ADM
DBMS_XSTREAM_ADM_UTL
DBMS_XSTREAM_AUTH_IVK
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved