Oracle | DBMS_STREAMS_ADM

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	GET_SCN_MAPPING	PURGE_SOURCE_CATALOG
ADD_GLOBAL_PROPAGATION_RULES	GET_TAG	RECOVER_OPERATION
ADD_GLOBAL_RULES	KEEP_COLUMNS	REMOVE_QUEUE
ADD_MESSAGE_PROPAGATION_RULE	MAINTAIN_GLOBAL	REMOVE_RULE
ADD_MESSAGE_RULE	MAINTAIN_SCHEMAS	REMOVE_STREAMS_CONFIGURATION
ADD_SCHEMA_PROPAGATION_RULES	MAINTAIN_SIMPLE_TABLESPACE	RENAME_COLUMN
ADD_SCHEMA_RULES	MAINTAIN_SIMPLE_TTS	RENAME_SCHEMA
ADD_SUBSET_PROPAGATION_RULES	MAINTAIN_TABLES	RENAME_TABLE
ADD_SUBSET_RULES	MAINTAIN_TABLESPACES	SET_MESSAGE_NOTIFICATION
ADD_TABLE_PROPAGATION_RULES	MAINTAIN_TTS	SET_MESSAGE_TRACKING
ADD_TABLE_RULES	MERGE_STREAMS	SET_RULE_TRANSFORM_FUNCTION
CLEANUP_INSTANTIATION_SETUP	MERGE_STREAMS_JOB	SET_TAG
DELETE_COLUMN	POST_INSTANTIATION_SETUP	SET_UP_QUEUE
GET_MESSAGE_TRACKING	PRE_INSTANTIATION_SETUP	SPLIT_STREAMS

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