Oracle DBMS_STREAMS_MC
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
Purpose Undocumented
AUTHID CURRENT_USER
Dependencies
DBA_CAPTURE DBMS_RECOVERABLE_SCRIPT DBMS_STREAMS_MT
DBA_DIRECTORIES DBMS_SQL DBMS_SYSTEM
DBA_RECOVERABLE_SCRIPT DBMS_STANDARD DBMS_SYS_ERROR
DBA_RECOVERABLE_SCRIPT_PARAMS DBMS_STREAMS_ADM_IVK DBMS_UTILITY
DBMS_ASSERT DBMS_STREAMS_ADM_UTL GLOBAL_NAME
DBMS_LOGREP_UTIL DBMS_STREAMS_DECL PLITBLM
DBMS_LOGREP_UTIL_INVOK DBMS_STREAMS_MC_INV  
Documented No
First Available 11.2.0.1
Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role
Source {ORACLE_HOME}/rdbms/admin/prvthsmc.plb
 
MAINTAIN_CHANGE_TABLE
Undocumented Change Table Management dbms_streams_mc.maintain_change_table(
invoking_pkg_owner       IN VARCHAR2,
invoking_pkg             IN VARCHAR2,
invoking_proc            IN VARCHAR2,
change_table_name        IN VARCHAR2,
source_table_name        IN VARCHAR2,
column_type_list         IN VARCHAR2,
extra_column_table       IN dbms_utility.uncl_array,
capture_values           IN VARCHAR2,
options_string           IN VARCHAR2,
script_name              IN VARCHAR2,
script_directory_object  IN VARCHAR2,
perform_actions          IN BOOLEAN,
capture_name             IN VARCHAR2,
propagation_name         IN VARCHAR2,
apply_name               IN VARCHAR2,
source_database          IN VARCHAR2,
destination_database     IN VARCHAR2,
keep_change_columns_only IN BOOLEAN,
execute_lcr              IN BOOLEAN);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_CAPTURE_ADM
DBMS_PROPAGATION_ADM
DBMS_STREAMS
DBMS_STREAMS_ADM
DBMS_STREAMS_ADM_UTL_INT
DBMS_STREAMS_AUTH
DBMS_STREAMS_CDC_ADM
DBMS_STREAMS_CONTROL_ADM
DBMS_STREAMS_HANDLER_ADM
DBMS_STREAMS_HANDLER_INTERNAL
DBMS_STREAMS_MC_INV
DBMS_STREAMS_MESSAGING
DBMS_STREAMS_PUB_RPC
DBMS_STREAMS_RPC_INTERNAL
DBMS_STREAMS_TABLESPACE_ADM
What's New In 12cR2
What's New In 18cR3

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