Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Static Data Dictionary Views, 50 of 521
ALL_MVIEW_AGGREGATES
describes the grouping functions (aggregate operations) that appear in the SELECT
list of materialized aggregate views accessible to the current user.
DBA_MVIEW_AGGREGATES
describes all such grouping functions defined for all materialized views in the database.
USER_MVIEW_AGGREGATES
describes all such grouping functions defined for all materialized views owned by the current user.
All three views exclude materialized views that reference remote tables or that include 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.
Column | Datatype | Null | Description |
---|---|---|---|
|
|
|
Owner of the materialized view |
|
|
|
Name of the materialized view |
|
|
|
Ordinal position of this aggregation within the |
|
|
|
Name of this column in the container table |
|
|
|
Aggregation function |
|
|
|
Whether this aggregation is distinct ( |
|
|
|
SQL text of the measure, excluding the aggregation function. Equal to |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|