3.170 ALL_ZONEMAPS
ALL_ZONEMAPS
describes all the zone maps accessible to the user.
Related Views
-
DBA_ZONEMAPS
describes all the zone maps in the database. -
USER_ZONEMAPS
describes all the zone maps owned by the user.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the zone map |
|
|
|
Name of the zone map |
|
|
|
Owner of the fact table of the zone map |
|
|
|
Name of the fact table on which the zone map is defined |
|
|
|
Scale factor of the zone map |
|
|
|
Indicates whether the zone map is hierarchical ( |
|
|
|
Indicates whether the zone map is created with the |
|
|
|
Zone map defining query |
|
|
|
Length of defining query in bytes |
|
|
|
Indicates whether the zone map is enabled for pruning ( |
|
|
|
Refresh mode for the zone map:
|
|
|
|
Refresh method for the zone map
|
|
|
|
The last refresh method used for the zone map:
|
|
|
|
Time of the last refresh |
|
|
|
Indicates whether the zone map is invalid due to some DDL ( |
|
|
|
Indicates whether the zone map is stale because of DML operations and cannot be used for pruning ( |
|
|
|
Indicates whether the zone map has been marked unusable by the owner ( |
|
|
|
Current compile state of the zone map:
Similar to |
Note:
This view is intended for use with Oracle Exadata release 12.1.2.1.1 or later.
See Also:
-
Oracle Database Data Warehousing Guide for more information about zone maps