Oracle8i Reference Release 2 (8.1.6) Part Number A76961-01 |
|
Static Data Dictionary Views, 47 of 452
ALL_MVIEW_KEYS
describes the columns or expressions in the SELECT
list upon which materialized views accessible to the current user are based.
DBA_MVIEW_KEYS
describes such columns and expressions for all materialized views in the database.
USER_MVIEW_KEYS
describes such columns and expressions for all materialized views owned by the current user.
All three views exclude materialized views that reference remote tables or that includes references to a nonstatic value such as SYSDATE
or USER
. These views also exclude materialized views that were created as "snapshots" prior to Oracle8i and that were never altered to enable query rewrite.
|
![]() Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
|