2.218 ALL_MVIEW_AGGREGATES
ALL_MVIEW_AGGREGATES
describes the grouping functions (aggregate operations) that appear in the SELECT
list of materialized aggregate views accessible to the current user.
Related Views
-
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.
Note:
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" before 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 |
|
|
|
Indicates whether this aggregation is distinct ( |
|
|
|
SQL text of the measure, excluding the aggregation function. Equal to |
See Also: