O'Reilly logo

Oracle in a Nutshell by David C. Kreines, Rick Greenwald

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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; ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required