Oracle DBMS_STREAMS_ADM_IVK
Version 21c

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 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_UTIL_INT
DBMS_STREAMS_ADM_UTIL_INVOK
DBMS_STREAMS_AUTH
DBMS_STREAMS_CONTROL_ADM
DBMS_STREAMS_PUB_RPC
DBMS_STREAMS_RPC_INTERNAL
DBMS_STREAMS_TABLESPACE_ADM
What's New In 19c
What's New In 20c-21c

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