Oracle DBMS_XRWMV
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 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 21c
What's New In 23c

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