Oracle DBMS_STREAMS_ADM_IVK
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows
Purpose Streams Internal Utilities
AUTHID CURRENT_USER
Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMS_STREAMS_ADM_IVK' UNION
SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMS_STREAMS_ADM_IVK'
ORDER BY 1;


Returns 63 objects
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;

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;

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
 
VERIFY_AND_GET_SUBSET_RULES (new 23ai)
Undocumented dbms_streams_adm_ivk.verify_and_get_subset_rules(
canon_own_name        IN  VARCHAR2,
canon_tab_name        IN  VARCHAR2,
table_name            IN  VARCHAR2,
type_value            IN  NUMBER,
inc_tagged_lcr        IN  NUMBER,
dml_condition         IN  VARCHAR2,
canon_source_database IN  VARCHAR2,
insert_rule           OUT VARCHAR2,
update_rule           OUT VARCHAR2,
delete_rule           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 26ai

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