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 available starting with Oracle Database 12c Release 1 (12.1.0.2), and 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