Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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; ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page