Oracle | DBMS

Oracle DBMS_XRWMV 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 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	XPLNMV_3GLT	XPLNRW_3GLCT
XPLNMV_3GLA	XPLNRW_3GLA	XPLNRW_3GLT
XPLNMV_3GLCA	XPLNRW_3GLCA	XPLNRW_EM_3GLT
XPLNMV_3GLCT

CLEANUP_3GL

Undocumented dbms_xrwmv.cleanup_3gl;

exec dbms_xrwmv.cleanup_3gl;

      

      PL/SQL procedure successfully completed.

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