Oracle in a Nutshell

Calls

PROCEDURE DBMS_MVIEW.BEGIN_TABLE_REORGANIZATION (tabowner IN VARCHAR2, tabname IN VARCHAR2);

Preserves materialized view data of tabname in tabowner schema.

PROCEDURE DBMS_MVIEW.END_TABLE_REORGANIZATION (tabowner IN VARCHAR2, tabname IN VARCHAR2);

Called after tabname in tabowner schema is reorganized to ensure that materialized view data is valid and that tabname is in proper state.

PROCEDURE DBMS_MVIEW.EXPLAIN_MVIEW (mv IN VARCHAR2, {statement_id IN VARCHAR2 := NULL | msg_array OUT SYS.EXPLAINMVARRAYTYPE});

Returns an explanation of the capabilities of mv. If you use the statement_id parameter, the output goes to the MV_CAPABILITIES_TABLE, which must exist. You must run the utlxmv.sql script before using. New with Oracle8i.

PROCEDURE DBMS_MVIEW.EXPLAIN_MVIEW (query IN VARCHAR2, mv IN VARCHAR2, {statement_id IN VARCHAR2 := NULL | msg_array OUT SYS.EXPLAINMVARRAYTYPE});

Returns an explanation of the rewrite of query using mv. If you use the statement_id parameter, the output goes to the REWRITE_TABLE, which is created when you run the utlxrw.sql script. New with Oracle9i.

FUNCTION DBMS_MVIEW.I_AM_A_REFRESH( ) RETURN BOOLEAN;

Returns TRUE if all local replication triggers for materialized views are disabled and FALSE if not. We like a function that identifies itself!

FUNCTION DBMS_MVIEW.PMARKER (rid IN ROWID) RETURN NUMBER;

Returns a partition marker from rid (the ROWID), which is used for Partition Change Tracking. New with Oracle9i.

PROCEDURE DBMS_MVIEW.PURGE_DIRECT_LOAD_LOG; ...