Oracle DBMS_XRWMV
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 Materialized View Management Utilities
AUTHID DEFINER
Dependencies
DBMS_ASSERT DBMS_XRW_LIB PRVT_TUNE_MVIEW
DBMS_SNAPSHOT_KKXRCA EXPLAINMVARRAYTYPE REWRITEARRAYTYPE
DBMS_XMV_LIB PRVT_SYS_TUNE_MVIEW  
Documented No
First Available Not known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtxrmv.plb
Subprograms
 
CLEANUP_3GL
Undocumented dbms_xrwmv.cleanup_3gl;
exec dbms_xrwmv.cleanup_3gl;
 
XPLNMV_3GLA
Undocumented dbms_xrwmv.xplnmv_3gla(
xmv_stmt   IN     VARCHAR2,
msg_array  IN OUT sys.explainmvarraytype,
tune_mview IN     BINARY_INTEGER);
TBD
 
XPLNMV_3GLCA
Undocumented dbms_xrwmv.xplnmv_3glca(
xmv_stmt   IN     CLOB,
msg_array  IN OUT sys.explainmvarraytype,
tune_mview IN BINARY_INTEGER);
TBD
 
XPLNMV_3GLCT
Undocumented dbms_xrwmv.xplnmv_3glct(
xmv_stmt IN CLOB,
tbowner  IN VARCHAR2,
tbname   IN VARCHAR2,
stmtid   IN VARCHAR2);
TBD
 
XPLNMV_3GLT
Undocumented dbms_xrwmv.xplnmv_3glt(
xmv_stmt IN VARCHAR2,
tbowner  IN VARCHAR2,
tbname   IN VARCHAR2);
TBD
 
XPLNRW_3GLA
Undocumented dbms_xrwmv.xplnrw_3gla(
sum_name  IN     VARCHAR2,
user_name IN     VARCHAR2,
query     IN     VARCHAR2,
msg_array IN OUT sys.rewritearraytype);
TBD
 
XPLNRW_3GLCA
Undocumented dbms_xrwmv.xplnrw_3glca(
sum_name  IN VARCHAR2,
user_name IN VARCHAR2,
query     IN CLOB,
msg_array IN OUT sys.rewritearraytype);
TBD
 
XPLNRW_3GLCT
Undocumented dbms_xrwmv.xplnrw_3glct(
sum_name     IN VARCHAR2,
user_name    IN VARCHAR2,
statement_id IN VARCHAR2,
query        IN CLOB,
msg_table    IN VARCHAR2)
TBD
 
XPLNRW_3GLT
Undocumented dbms_xrwmv.xplnrw_3glt(
sum_name     IN VARCHAR2,
user_name    IN VARCHAR2,
statement_id IN VARCHAR2,
query        IN VARCHAR2,
msg_table    IN VARCHAR2)
TBD
 
XPLNRW_EM_3GLT
Undocumented dbms_xrwmv.xplnrw_em_3glt(
sum_name     IN VARCHAR2,
user_name    IN VARCHAR2,
statement_id IN VARCHAR2,
query        IN VARCHAR2,
msg_table    IN VARCHAR2,
schemaid     IN VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_MVIEW
DBMS_SNAPSHOT_COMMON
DBMS_SNAPSHOT_KKXRCA
DBMS_SNAPSHOT_UTL
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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx