Oracle DBMS_XSTREAM_UTL_IVK
Version 18.3

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.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 18c
What's New In 19c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx