Calls
-
PROCEDURE DBMS_MVIEW.BEGIN_TABLE_REORGANIZATION(tabownerIN VARCHAR2,tabnameIN VARCHAR2); Preserves materialized view data of tabname in tabowner schema.
-
PROCEDURE DBMS_MVIEW.END_TABLE_REORGANIZATION(tabownerIN VARCHAR2,tabnameIN 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(mvIN VARCHAR2,{statement_idIN VARCHAR2 := NULL |msg_arrayOUT 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(queryIN VARCHAR2,mvIN VARCHAR2,{statement_idIN VARCHAR2 := NULL |msg_arrayOUT 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(ridIN 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; ...