Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Static Data Dictionary Views, 53 of 521
ALL_MVIEW_JOINS
describes joins between two columns in the WHERE
clause of the subquery that defines a materialized view accessible to the current user.
DBA_MVIEW_JOINS
describes all such joins for all materialized views in the database.
USER_MVIEW_JOINS
describes such joins 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-2001, Oracle Corporation. All Rights Reserved. |
|