Oracle DBMS_STREAMS_ADM_IVK
Version 21c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
Purpose Streams Internal Utilities
AUTHID CURRENT_USER
Dependencies
ALL_ARGUMENTS DBMS_APPLY_ADM_INTERNAL DBMS_STREAMS_DECL
ANYDATA DBMS_AQ DBMS_STREAMS_MT
ANYTYPE DBMS_AQADM DBMS_STREAMS_RPC
AQ$_AGENT DBMS_AQADM_SYS DBMS_STREAMS_SM
AQ$_REG_INFO DBMS_CAPTURE_ADM DBMS_STREAMS_TABLESPACE_ADM
AQ$_REG_INFO_LIST DBMS_CAPTURE_ADM_INTERNAL DBMS_SYSTEM
DBA_APPLY DBMS_FLASHBACK DBMS_UTILITY
DBA_APPLY_CONFLICT_COLUMNS DBMS_INTERNAL_TRIGGER DBMS_XSTREAM_ADM
DBA_APPLY_DML_HANDLERS DBMS_LOGMNR DBMS_XSTREAM_GG_ADM
DBA_APPLY_INSTANTIATED_GLOBAL DBMS_LOGREP_LIB DBMS_XSTREAM_UTL_IVK
DBA_APPLY_INSTANTIATED_OBJECTS DBMS_LOGREP_UTIL GLOBAL_NAME
DBA_APPLY_INSTANTIATED_SCHEMAS DBMS_LOGREP_UTIL_INVOK OBJ$
DBA_APPLY_KEY_COLUMNS DBMS_PROPAGATION_ADM RE$NV_ARRAY
DBA_CAPTURE DBMS_PROPAGATION_INTERNAL RE$NV_LIST
DBA_CAPTURE_PREPARED_DATABASE DBMS_RULEADM_INTERNAL RE$VARIABLE_TYPE
DBA_CAPTURE_PREPARED_SCHEMAS DBMS_RULE_ADM RE$VARIABLE_TYPE_LIST
DBA_CAPTURE_PREPARED_TABLES DBMS_SQL STREAMS$TRANSFORMATION_INFO
DBA_PROPAGATION DBMS_STANDARD STREAMS$_APPLY_MILESTONE
DBA_STREAMS_MESSAGE_CONSUMERS DBMS_STREAMS_ADM STREAMS$_APPLY_PROCESS
DBA_SYNC_CAPTURE DBMS_STREAMS_ADM_UTL STREAMS$_APPLY_PROGRESS
DBA_SYNC_CAPTURE_PREPARED_TABS DBMS_STREAMS_ADM_UTL_INVOK UTL_RAW
DBMS_APPLY_ADM    
Documented No
First Available 12.1
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvthstr.plb
{ORACLE_HOME}/rdbms/admin/prvtbstr.plb
Subprograms
 
ADD_COLUMN
Undocumented dbms_streams_adm_ivk.add_column(
rule_name    IN VARCHAR2,
table_name   IN VARCHAR2,
column_name  IN VARCHAR2,
column_value IN sys.anydata,
value_type   IN VARCHAR2,
step_number  IN NUMBER,
operation    IN VARCHAR2);
TBD
Overload 2 dbms_streams_adm_ivk.add_column(
rule_name       IN VARCHAR2,
table_name      IN VARCHAR2,
column_name     IN VARCHAR2,
column_function IN VARCHAR2,
value_type      IN VARCHAR2,
step_number     IN NUMBER,
operation       IN VARCHAR2);
TBD
 
ADD_GLOBAL_PROPAGATION_RULES
Undocumented dbms_streams_adm_ivk.add_global_propagation_rules(
streams_name           IN VARCHAR2,
source_queue_name      IN VARCHAR2,
destination_queue_name IN VARCHAR2,
include_dml            IN BOOLEAN,
include_ddl            IN BOOLEAN,
include_tagged_lcr     IN BOOLEAN,
source_database        IN VARCHAR2,
inclusion_rule         IN BOOLEAN,
and_condition          IN VARCHAR2,
queue_to_queue         IN BOOLEAN);
TBD
Overload 2 dbms_streams_adm_ivk.add_global_propagation_rules(
streams_name           IN  VARCHAR2,
source_queue_name      IN  VARCHAR2,
destination_queue_name IN  VARCHAR2,
include_dml            IN  BOOLEAN,
include_ddl            IN  BOOLEAN,
include_tagged_lcr     IN  BOOLEAN,
source_database        IN  VARCHAR2,
dml_rule_name          OUT VARCHAR2,
ddl_rule_name          OUT VARCHAR2,
inclusion_rule         IN  BOOLEAN,
and_condition          IN  VARCHAR2,
queue_to_queue         IN  BOOLEAN);
TBD
 
ADD_GLOBAL_RULES
Undocumented dbms_streams_adm_ivk.add_global_rules(
streams_type       IN VARCHAR2,
streams_name       IN VARCHAR2,
queue_name         IN VARCHAR2,
include_dml        IN BOOLEAN,
include_ddl        IN BOOLEAN,
include_tagged_lcr IN BOOLEAN,
source_database    IN VARCHAR2,
inclusion_rule     IN BOOLEAN,
and_condition      IN VARCHAR2);
TBD
Overload 2 dbms_streams_adm_ivk.add_global_rules(
streams_type       IN  VARCHAR2,
streams_name       IN  VARCHAR2,
queue_name         IN  VARCHAR2,
include_dml        IN  BOOLEAN,
include_ddl        IN  BOOLEAN,
include_tagged_lcr IN  BOOLEAN,
source_database    IN  VARCHAR2,
dml_rule_name      OUT VARCHAR2,
ddl_rule_name      OUT VARCHAR2,
inclusion_rule     IN  BOOLEAN,
and_condition      IN  VARCHAR2);
TBD
 
ADD_MESSAGE_PROPAGATION_RULE
Undocumented dbms_streams_adm_ivk.add_message_propagation_rule(
message_type           IN VARCHAR2,
rule_condition         IN VARCHAR2,
streams_name           IN VARCHAR2,
source_queue_name      IN VARCHAR2,
destination_queue_name IN VARCHAR2,
inclusion_rule         IN BOOLEAN,
queue_to_queue         IN BOOLEAN);
TBD
Overload 2 dbms_streams_adm_ivk.add_message_propagation_rule(
message_type           IN  VARCHAR2,
rule_condition         IN  VARCHAR2,
streams_name           IN  VARCHAR2,
source_queue_name      IN  VARCHAR2,
destination_queue_name IN  VARCHAR2,
inclusion_rule         IN  BOOLEAN,
rule_name              OUT VARCHAR2,
queue_to_queue         IN  BOOLEAN);
TBD
 
ADD_MESSAGE_RULE
Undocumented dbms_streams_adm_ivk.add_message_rule(
message_type   IN VARCHAR2,
rule_condition IN VARCHAR2,
streams_type   IN VARCHAR2,
streams_name   IN VARCHAR2,
queue_name     IN VARCHAR2,
inclusion_rule IN BOOLEAN);
TBD
Overload 2 dbms_streams_adm_ivk.add_message_rule(
message_type   IN  VARCHAR2,
rule_condition IN  VARCHAR2,
streams_type   IN  VARCHAR2,
streams_name   IN  VARCHAR2,
queue_name     IN  VARCHAR2,
inclusion_rule IN  BOOLEAN,
rule_name      OUT VARCHAR2);
TBD
 
ADD_SCHEMA_PROPAGATION_RULES
Undocumented dbms_streams_adm_ivk.add_schema_propagation_rules(
schema_name            IN VARCHAR2,
streams_name           IN VARCHAR2,
source_queue_name      IN VARCHAR2,
destination_queue_name IN VARCHAR2,
include_dml            IN BOOLEAN,
include_ddl            IN BOOLEAN,
include_tagged_lcr     IN BOOLEAN,
source_database        IN VARCHAR2,
inclusion_rule         IN BOOLEAN,
and_condition          IN VARCHAR2,
queue_to_queue         IN BOOLEAN);
TBD
Overload 2 dbms_streams_adm_ivk.add_schema_propagation_rules(
schema_name            IN  VARCHAR2,
streams_name           IN  VARCHAR2,
source_queue_name      IN  VARCHAR2,
destination_queue_name IN  VARCHAR2,
include_dml            IN  BOOLEAN,
include_ddl            IN  BOOLEAN,
include_tagged_lcr     IN  BOOLEAN,
source_database        IN  VARCHAR2,
dml_rule_name          OUT VARCHAR2,
ddl_rule_name          OUT VARCHAR2,
inclusion_rule         IN  BOOLEAN,
and_condition          IN  VARCHAR2,
queue_to_queue         IN  BOOLEAN);
TBD
 
ADD_SCHEMA_RULES
Undocumented dbms_streams_adm_ivk.add_schema_rules(
schema_name        IN VARCHAR2,
streams_type       IN VARCHAR2,
streams_name       IN VARCHAR2,
queue_name         IN VARCHAR2,
include_dml        IN BOOLEAN,
include_ddl        IN BOOLEAN,
include_tagged_lcr IN BOOLEAN,
source_database    IN VARCHAR2,
inclusion_rule     IN BOOLEAN,
and_condition      IN VARCHAR2);
TBD
Overload 2 dbms_streams_adm_ivk.add_schema_rules(
schema_name        IN  VARCHAR2,
streams_type       IN  VARCHAR2,
streams_name       IN  VARCHAR2,
queue_name         IN  VARCHAR2,
include_dml        IN  BOOLEAN,
include_ddl        IN  BOOLEAN,
include_tagged_lcr IN  BOOLEAN,
source_database    IN  VARCHAR2,
dml_rule_name      OUT VARCHAR2,
ddl_rule_name      OUT VARCHAR2,
inclusion_rule     IN  BOOLEAN,
and_condition      IN  VARCHAR2);
TBD
 
ADD_SUBSET_PROPAGATION_RULES
Undocumented dbms_streams_adm_ivk.add_subset_propagation_rules(
table_name             IN VARCHAR2,
dml_condition          IN VARCHAR2,
streams_name           IN VARCHAR2,
source_queue_name      IN VARCHAR2,
destination_queue_name IN VARCHAR2,
include_tagged_lcr     IN BOOLEAN,
source_database        IN VARCHAR2,
queue_to_queue         IN BOOLEAN);
TBD
Overload 2 dbms_streams_adm_ivk.add_subset_propagation_rules(
table_name             IN  VARCHAR2,
dml_condition          IN  VARCHAR2,
streams_name           IN  VARCHAR2,
source_queue_name      IN  VARCHAR2,
destination_queue_name IN  VARCHAR2,
include_tagged_lcr     IN  BOOLEAN,
source_database        IN  VARCHAR2,
insert_rule_name       OUT VARCHAR2,
update_rule_name       OUT VARCHAR2,
delete_rule_name       OUT VARCHAR2,
queue_to_queue         IN  BOOLEAN);
TBD
 
ADD_SUBSET_RULES
Undocumented dbms_streams_adm_ivk.add_subset_rules(
table_name         IN VARCHAR2,
dml_condition      IN VARCHAR2,
streams_type       IN VARCHAR2,
streams_name       IN VARCHAR2,
queue_name         IN VARCHAR2,
include_tagged_lcr IN BOOLEAN,
source_database    IN VARCHAR2,
source_root_name   IN VARCHAR2);
TBD
Overload 2 dbms_streams_adm_ivk.add_subset_rules(
table_name         IN  VARCHAR2,
dml_condition      IN  VARCHAR2,
streams_type       IN  VARCHAR2,
streams_name       IN  VARCHAR2,
queue_name         IN  VARCHAR2,
include_tagged_lcr IN  BOOLEAN,
source_database    IN  VARCHAR2,
insert_rule_name   OUT VARCHAR2,
update_rule_name   OUT VARCHAR2,
delete_rule_name   OUT VARCHAR2,
source_root_name   IN  VARCHAR2);
TBD
 
ADD_TABLE_PROPAGATION_RULES
Undocumented dbms_streams_adm_ivk.add_table_propagation_rules(
table_name             IN VARCHAR2,
streams_name           IN VARCHAR2,
source_queue_name      IN VARCHAR2,
destination_queue_name IN VARCHAR2,
include_dml            IN BOOLEAN,
include_ddl            IN BOOLEAN,
include_tagged_lcr     IN BOOLEAN,
source_database        IN VARCHAR2,
inclusion_rule         IN BOOLEAN,
and_condition          IN VARCHAR2,
queue_to_queue         IN BOOLEAN);
TBD
Overload 2 dbms_streams_adm_ivk.add_table_propagation_rules(
table_name             IN  VARCHAR2,
streams_name           IN  VARCHAR2,
source_queue_name      IN  VARCHAR2,
destination_queue_name IN  VARCHAR2,
include_dml            IN  BOOLEAN,
include_ddl            IN  BOOLEAN,
include_tagged_lcr     IN  BOOLEAN,
source_database        IN  VARCHAR2,
dml_rule_name          OUT VARCHAR2,
ddl_rule_name          OUT VARCHAR2,
inclusion_rule         IN  BOOLEAN,
and_condition          IN  VARCHAR2,
queue_to_queue         IN  BOOLEAN);
TBD
 
ADD_TABLE_RULES
Undocumented dbms_streams_adm_ivk.add_table_rules(
table_name         IN VARCHAR2,
streams_type       IN VARCHAR2,
streams_name       IN VARCHAR2,
queue_name         IN VARCHAR2,
include_dml        IN BOOLEAN,
include_ddl        IN BOOLEAN,
include_tagged_lcr IN BOOLEAN,
source_database    IN VARCHAR2,
inclusion_rule     IN BOOLEAN,
and_condition      IN VARCHAR2);
TBD
Overload 2 dbms_streams_adm_ivk.add_table_rules(
table_name         IN  VARCHAR2,
streams_type       IN  VARCHAR2,
streams_name       IN  VARCHAR2,
queue_name         IN  VARCHAR2,
include_dml        IN  BOOLEAN,
include_ddl        IN  BOOLEAN,
include_tagged_lcr IN  BOOLEAN,
source_database    IN  VARCHAR2,
dml_rule_name      OUT VARCHAR2,
ddl_rule_name      OUT VARCHAR2,
inclusion_rule     IN  BOOLEAN,
and_condition      IN  VARCHAR2);
TBD
 
CLEANUP_INSTANTIATION_SETUP
Undocumented dbms_streams_adm_ivk.cleanup_instantiation_setup(
maintain_mode           IN VARCHAR2,
tablespace_names        IN sys.dbms_streams_tablespace_adm.tablespace_set,
source_database         IN VARCHAR2,
destination_database    IN VARCHAR2,
perform_actions         IN BOOLEAN,
script_name             IN VARCHAR2,
script_directory_object IN VARCHAR2,
capture_name            IN VARCHAR2,
capture_queue_table     IN VARCHAR2,
capture_queue_name      IN VARCHAR2,
capture_queue_user      IN VARCHAR2,
propagation_name        IN VARCHAR2,
apply_name              IN VARCHAR2,
apply_queue_table       IN VARCHAR2,
apply_queue_name        IN VARCHAR2,
apply_queue_user        IN VARCHAR2,
bi_directional          IN BOOLEAN,
change_global_name      IN BOOLEAN);
TBD
 
DELETE_COLUMN
Undocumented dbms_streams_adm_ivk.delete_column(
rule_name   IN VARCHAR2,
table_name  IN VARCHAR2,
column_name IN VARCHAR2,
value_type  IN VARCHAR2,
step_number IN NUMBER,
operation   IN VARCHAR2);
TBD
 
GET_MESSAGE_TRACKING
Undocumented dbms_streams_adm_ivk.get_message_tracking RETURN VARCHAR2;
SELECT dbms_streams_adm_ivk.get_message_tracking
FROM dual;

GET_MESSAGE_TRACKING
---------------------
 
 
GET_SCN_MAPPING
Undocumented dbms_streams_adm_ivk.get_scn_mapping(
apply_name             IN  VARCHAR2,
src_pit_scn            IN  NUMBER,
dest_instantiation_scn OUT NUMBER,
dest_start_scn         OUT NUMBER,
dest_skip_txn_ids      OUT sys.dbms_utility.name_array);
TBD
 
GET_TAG
Undocumented dbms_streams_adm_ivk.get_tag RETURN RAW;
SELECT dbms_streams_adm_ivk.get_tag
FROM dual;

GET_TAG
---------------------
 
 
KEEP_COLUMNS
Undocumented dbms_streams_adm_ivk.keep_columns(
rule_name    IN VARCHAR2,
table_name   IN VARCHAR2,
column_table IN sys.dbms_utility.lname_array,
value_type   IN VARCHAR2,
step_number  IN NUMBER,
operation    IN VARCHAR2);
TBD
Overload 2 dbms_streams_adm_ivk.keep_columns(
rule_name   IN VARCHAR2,
table_name  IN VARCHAR2,
column_list IN VARCHAR2,
value_type  IN VARCHAR2,
step_number IN NUMBER,
operation   IN VARCHAR2);
TBD
 
MAINTAIN_GLOBAL
Undocumented dbms_streams_adm_ivk.maintain_global(
source_directory_object      IN VARCHAR2,
destination_directory_object IN VARCHAR2,
source_database              IN VARCHAR2,
destination_database         IN VARCHAR2,
perform_actions              IN BOOLEAN,
script_name                  IN VARCHAR2,
script_directory_object      IN VARCHAR2,
dump_file_name               IN VARCHAR2,
capture_name                 IN VARCHAR2,
capture_queue_table          IN VARCHAR2,
capture_queue_name           IN VARCHAR2,
capture_queue_user           IN VARCHAR2,
propagation_name             IN VARCHAR2,
apply_name                   IN VARCHAR2,
apply_queue_table            IN VARCHAR2,
apply_queue_name             IN VARCHAR2,
apply_queue_user             IN VARCHAR2,
log_file                     IN VARCHAR2,
bi_directional               IN BOOLEAN,
include_ddl                  IN BOOLEAN,
instantiation                IN BINARY_INTEGER);
TBD
 
MAINTAIN_SCHEMAS
Undocumented dbms_streams_adm_ivk.maintain_schemas(
schema_names                 IN sys.dbms_utility.uncl_array,
source_directory_object      IN VARCHAR2,
destination_directory_object IN VARCHAR2,
source_database              IN VARCHAR2,
destination_database         IN VARCHAR2,
perform_actions              IN BOOLEAN,
script_name                  IN VARCHAR2,
script_directory_object      IN VARCHAR2,
dump_file_name               IN VARCHAR2,
capture_name                 IN VARCHAR2,
capture_queue_table          IN VARCHAR2,
capture_queue_name           IN VARCHAR2,
capture_queue_user           IN VARCHAR2,
propagation_name             IN VARCHAR2,
apply_name                   IN VARCHAR2,
apply_queue_table            IN VARCHAR2,
apply_queue_name             IN VARCHAR2,
apply_queue_user             IN VARCHAR2,
log_file                     IN VARCHAR2,
bi_directional               IN BOOLEAN,
include_ddl                  IN BOOLEAN,
instantiation                IN BINARY_INTEGER);
TBD
Overload 2 dbms_streams_adm_ivk.maintain_schemas(
schema_names                     IN VARCHAR2,
source_directory_object          IN VARCHAR2,
destination_directory_object     IN VARCHAR2,
source_database                  IN VARCHAR2,
destination_database             IN VARCHAR2,
perform_actions                  IN BOOLEAN,
script_name                      IN VARCHAR2,
script_directory_object          IN VARCHAR2,
dump_file_name                   IN VARCHAR2,
capture_name                     IN VARCHAR2,
capture_queue_table              IN VARCHAR2,
capture_queue_name               IN VARCHAR2,
capture_queue_user               IN VARCHAR2,
propagation_name                 IN VARCHAR2,
apply_name                       IN VARCHAR2,
apply_queue_table                IN VARCHAR2,
apply_queue_name                 IN VARCHAR2,
apply_queue_user                 IN VARCHAR2,
log_file                         IN VARCHAR2,
bi_directional                   IN BOOLEAN,
include_ddl                      IN BOOLEAN,
instantiation                    IN BINARY_INTEGER);
TBD
 
MAINTAIN_SIMPLE_TABLESPACE
Undocumented dbms_streams_adm_ivk.maintain_simple_tablespace(
tablespace_name              IN VARCHAR2,
source_directory_object      IN VARCHAR2,
destination_directory_object IN VARCHAR2,
destination_database         IN VARCHAR2,
setup_streams                IN BOOLEAN,
script_name                  IN VARCHAR2,
script_directory_object      IN VARCHAR2,
bi_directional               IN BOOLEAN);
TBD
 
MAINTAIN_SIMPLE_TTS
Undocumented dbms_streams_adm_ivk.maintain_simple_tts(
tablespace_name              IN VARCHAR2,
source_directory_object      IN VARCHAR2,
destination_directory_object IN VARCHAR2,
source_database              IN VARCHAR2,
destination_database         IN VARCHAR2,
perform_actions              IN BOOLEAN,
script_name                  IN VARCHAR2,
script_directory_object      IN VARCHAR2,
bi_directional               IN BOOLEAN);
TBD
 
MAINTAIN_TABLES
Undocumented dbms_streams_adm_ivk.maintain_tables(
table_names                  IN sys.dbms_utility.uncl_array,
source_directory_object      IN VARCHAR2,
destination_directory_object IN VARCHAR2,
source_database              IN VARCHAR2,
destination_database         IN VARCHAR2,
perform_actions              IN BOOLEAN,
script_name                  IN VARCHAR2,
script_directory_object      IN VARCHAR2,
dump_file_name               IN VARCHAR2,
capture_name                 IN VARCHAR2,
capture_queue_table          IN VARCHAR2,
capture_queue_name           IN VARCHAR2,
capture_queue_user           IN VARCHAR2,
propagation_name             IN VARCHAR2,
apply_name                   IN VARCHAR2,
apply_queue_table            IN VARCHAR2,
apply_queue_name             IN VARCHAR2,
apply_queue_user             IN VARCHAR2,
log_file                     IN VARCHAR2,
bi_directional               IN BOOLEAN,
include_ddl                  IN BOOLEAN,
instantiation                IN BINARY_INTEGER);
TBD
Overload 2 dbms_streams_adm_ivk.maintain_tables(
table_names                  IN VARCHAR2,
source_directory_object      IN VARCHAR2,
destination_directory_object IN VARCHAR2,
source_database              IN VARCHAR2,
destination_database         IN VARCHAR2,
perform_actions              IN BOOLEAN,
script_name                  IN VARCHAR2,
script_directory_object      IN VARCHAR2,
dump_file_name               IN VARCHAR2,
capture_name                 IN VARCHAR2,
capture_queue_table          IN VARCHAR2,
capture_queue_name           IN VARCHAR2,
capture_queue_user           IN VARCHAR2,
propagation_name             IN VARCHAR2,
apply_name                   IN VARCHAR2,
apply_queue_table            IN VARCHAR2,
apply_queue_name             IN VARCHAR2,
apply_queue_user             IN VARCHAR2,
log_file                     IN VARCHAR2,
bi_directional               IN BOOLEAN,
include_ddl                  IN BOOLEAN,
instantiation                IN BINARY_INTEGER);
TBD
 
MAINTAIN_TABLESPACES
Undocumented dbms_streams_adm_ivk.maintain_tablespaces(
tablespace_names             IN sys.dbms_streams_tablespace_adm.tablespace_set,
source_directory_object      IN VARCHAR2,
destination_directory_object IN VARCHAR2,
destination_database         IN VARCHAR2,
setup_streams                IN BOOLEAN,
script_name                  IN VARCHAR2,
script_directory_object      IN VARCHAR2,
dump_file_name               IN VARCHAR2,
source_queue_table           IN VARCHAR2,
source_queue_name            IN VARCHAR2,
source_queue_user            IN VARCHAR2,
destination_queue_table      IN VARCHAR2,
destination_queue_name       IN VARCHAR2,
destination_queue_user       IN VARCHAR2,
capture_name                 IN VARCHAR2,
propagation_name             IN VARCHAR2,
apply_name                   IN VARCHAR2,
log_file                     IN VARCHAR2,
bi_directional               IN BOOLEAN,
include_ddl                  IN BOOLEAN);
TBD
 
MAINTAIN_TTS
Undocumented dbms_streams_adm_ivk.maintain_tts(
tablespace_names             IN dbms_streams_tablespace_adm.tablespace_set,
source_directory_object      IN VARCHAR2,
destination_directory_object IN VARCHAR2,
source_database              IN VARCHAR2,
destination_database         IN VARCHAR2,
perform_actions              IN BOOLEAN,
script_name                  IN VARCHAR2,
script_directory_object      IN VARCHAR2,
dump_file_name               IN VARCHAR2,
capture_name                 IN VARCHAR2,
capture_queue_table          IN VARCHAR2,
capture_queue_name           IN VARCHAR2,
capture_queue_user           IN VARCHAR2,
propagation_name             IN VARCHAR2,
apply_name                   IN VARCHAR2,
apply_queue_table            IN VARCHAR2,
apply_queue_name             IN VARCHAR2,
apply_queue_user             IN VARCHAR2,
log_file                     IN VARCHAR2,
bi_directional               IN BOOLEAN,
include_ddl                  IN BOOLEAN);
TBD
 
MERGE_STREAMS
Undocumented dbms_streams_adm_ivk.merge_streams(
cloned_propagation_name IN VARCHAR2,
propagation_name        IN VARCHAR2,
queue_name              IN VARCHAR2,
perform_actions         IN BOOLEAN,
script_name             IN VARCHAR2,
script_directory_object IN VARCHAR2)
TBD
 
MERGE_STREAMS_JOB
Undocumented dbms_streams_adm_ivk.merge_streams_job(
cloned_propagation_name IN VARCHAR2,
propagation_name        IN VARCHAR2,
queue_name              IN VARCHAR2,
merge_threshold         IN NUMBER,
schedule_name           IN VARCHAR2,
merge_job_name          IN VARCHAR2);
TBD
 
POST_INSTANTIATION_SETUP
Undocumented dbms_streams_adm_ivk.post_instantiation_setup(
maintain_mode           IN VARCHAR2,
tablespace_names        IN sys.dbms_streams_tablespace_adm.tablespace_set,
source_database         IN VARCHAR2,
destination_database    IN VARCHAR2,
perform_actions         IN BOOLEAN,
script_name             IN VARCHAR2,
script_directory_object IN VARCHAR2,
capture_name            IN VARCHAR2,
capture_queue_table     IN VARCHAR2,
capture_queue_name      IN VARCHAR2,
capture_queue_user      IN VARCHAR2,
propagation_name        IN VARCHAR2,
apply_name              IN VARCHAR2,
apply_queue_table       IN VARCHAR2,
apply_queue_name        IN VARCHAR2,
apply_queue_user        IN VARCHAR2,
bi_directional          IN BOOLEAN,
include_ddl             IN BOOLEAN,
start_processes         IN BOOLEAN,
instantiation_scn       IN NUMBER,
exclude_schemas         IN VARCHAR2,
exclude_flags           IN BINARY_INTEGER);
TBD
 
PRE_INSTANTIATION_SETUP
Undocumented dbms_streams_adm_ivk.pre_instantiation_setup(
maintain_mode           IN VARCHAR2,
tablespace_names        IN sys.dbms_streams_tablespace_adm.tablespace_set,
source_database         IN VARCHAR2,
destination_database    IN VARCHAR2,
perform_actions         IN BOOLEAN,
script_name             IN VARCHAR2,
script_directory_object IN VARCHAR2,
capture_name            IN VARCHAR2,
capture_queue_table     IN VARCHAR2,
capture_queue_name      IN VARCHAR2,
capture_queue_user      IN VARCHAR2,
propagation_name        IN VARCHAR2,
apply_name              IN VARCHAR2,
apply_queue_table       IN VARCHAR2,
apply_queue_name        IN VARCHAR2,
apply_queue_user        IN VARCHAR2,
bi_directional          IN BOOLEAN,
include_ddl             IN BOOLEAN,
start_processes         IN BOOLEAN,
exclude_schemas         IN VARCHAR2,
exclude_flags           IN BINARY_INTEGER);
TBD
 
PURGE_SOURCE_CATALOG
Undocumented dbms_streams_adm_ivk.purge_source_catalog(
source_database    IN VARCHAR2,
source_object_name IN VARCHAR2,
source_object_type IN VARCHAR2);
TBD
 
RECOVER_OPERATION
Undocumented dbms_streams_adm_ivk.recover_operation(
script_id      IN RAW,
operation_mode IN VARCHAR2);
TBD
 
REMOVE_QUEUE
Undocumented dbms_streams_adm_ivk.remove_queue(
queue_name              IN VARCHAR2,
cascade                 IN BOOLEAN,
drop_unused_queue_table IN BOOLEAN);
TBD
 
REMOVE_RULE
Undocumented dbms_streams_adm_ivk.remove_rule(
rule_name        IN VARCHAR2,
streams_type     IN VARCHAR2,
streams_name     IN VARCHAR2,
drop_unused_rule IN BOOLEAN,
inclusion_rule   IN BOOLEAN);
TBD
 
REMOVE_STREAMS_CONFIGURATION
Undocumented dbms_streams_adm_ivk.remove_streams_configuration(
container IN VARCHAR2,
level     IN BINARY_INTEGER);
TBD
 
RENAME_COLUMN
Undocumented dbms_streams_adm_ivk.rename_column(
rule_name        IN VARCHAR2,
table_name       IN VARCHAR2,
from_column_name IN VARCHAR2,
to_column_name   IN VARCHAR2,
value_type       IN VARCHAR2,
step_number      IN NUMBER,
operation        IN VARCHAR2);
TBD
 
RENAME_SCHEMA
Undocumented dbms_streams_adm_ivk.rename_schema(
rule_name        IN VARCHAR2,
from_schema_name IN VARCHAR2,
to_schema_name   IN VARCHAR2,
step_number      IN NUMBER,
operation        IN VARCHAR2);
TBD
 
RENAME_TABLE
Undocumented dbms_streams_adm_ivk.rename_table(
rule_name       IN VARCHAR2,
from_table_name IN VARCHAR2,
to_table_name   IN VARCHAR2,
step_number     IN NUMBER,
operation       IN VARCHAR2);
TBD
 
SET_MESSAGE_NOTIFICATION
Undocumented dbms_streams_adm_ivk.set_message_notification(
streams_name         IN VARCHAR2,
notification_action  IN VARCHAR2,
notification_type    IN VARCHAR2,
notification_context IN sys.anydata,
include_notification IN BOOLEAN,
queue_name           IN VARCHAR2);
TBD
 
SET_MESSAGE_TRACKING
Undocumented dbms_streams_adm_ivk.set_message_tracking(
tracking_label IN VARCHAR2,
actions        IN NUMBER);
TBD
 
SET_RULE_TRANSFORM_FUNCTION
Undocumented dbms_streams_adm_ivk.set_rule_transform_function(
rule_name          IN VARCHAR2,
transform_function IN VARCHAR2)
TBD
 
SET_TAG
Undocumented dbms_streams_adm_ivk.set_tag(tag IN RAW);
TBD
 
SET_UP_QUEUE
Undocumented dbms_streams_adm_ivk.set_up_queue(
queue_table    IN VARCHAR2,
storage_clause IN VARCHAR2,
queue_name     IN VARCHAR2,
queue_user     IN VARCHAR2,
comment        IN VARCHAR2)
TBD
 
SPLIT_STREAMS
Undocumented dbms_streams_adm_ivk.split_streams(
propagation_name        IN     VARCHAR2,
cloned_propagation_name IN     VARCHAR2,
cloned_queue_name       IN     VARCHAR2,
cloned_capture_name     IN     VARCHAR2,
perform_actions         IN     BOOLEAN,
script_name             IN     VARCHAR2,
script_directory_object IN     VARCHAR2,
auto_merge_threshold    IN     NUMBER,
schedule_name           IN OUT VARCHAR2,
merge_job_name          IN OUT VARCHAR2
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_CAPTURE_ADM
DBMS_PROPAGATION_ADM
DBMS_RECOVERABLE_SCRIPT
DBMS_STREAMS
DBMS_STREAMS_ADM
DBMS_STREAMS_ADM_UTL_INT
DBMS_STREAMS_ADM_UTL_INVOK
DBMS_STREAMS_AUTH
DBMS_STREAMS_CONTROL_ADM
DBMS_STREAMS_PUB_RPC
DBMS_STREAMS_RPC_INTERNAL
DBMS_STREAMS_TABLESPACE_ADM
What's New In 21c
What's New In 23c

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