Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E41527-09
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_ZONEMAPS

ALL_ZONEMAPS describes all the zone maps accessible to the user.

Related Views

Column Datatype NULL Description
OWNER VARCHAR2(128)   Owner of the zone map
ZONEMAP_NAME VARCHAR2(128)   Name of the zone map
FACT_OWNER VARCHAR2(128)   Owner of the fact table of the zone map
FACT_TABLE VARCHAR2(128)   Name of the fact table on which the zone map is defined
SCALE NUMBER   Scale factor of the zone map
HIERARCHICAL VARCHAR2(12)   Indicates whether the zone map is hierarchical (YES) or not (NO)
WITH_CLUSTERING VARCHAR2(15)   Indicates whether the zone map is created with the CLUSTERING clause (YES) or not (NO)
QUERY LONG   Zone map defining query
QUERY_LEN NUMBER(38)   Length of defining query in bytes
PRUNING VARCHAR2(8)   Indicates whether the zone map is enabled for pruning (ENABLED) or not (DISABLED)
REFRESH_MODE VARCHAR2(17)   Refresh mode for the zone map:
  • COMMIT

  • DEMAND

  • DATAMOVEMENT

  • LOAD

  • LOAD DATAMOVEMENT

REFRESH_METHOD VARCHAR2(14)   Refresh method for the zone map
  • COMPLETE

  • FORCE

  • FAST

LAST_REFRESH_METHOD VARCHAR2(19)   The last refresh method used for the zone map:
  • NA

  • COMPLETE

  • FAST

  • ERROR-UNKNOWN

LAST_REFRESH_TIME TIMESTAMP(9)   Time of the last refresh
INVALID VARCHAR2(7)   Indicates whether the zone map is invalid due to some DDL (YES) or not (NO)
STALE VARCHAR2(7)   Indicates whether the zone map is stale because of DML operations and cannot be used for pruning (YES) or not (NO) or whether this cannot be determined (UNKNOWN)
UNUSABLE VARCHAR2(8)   Indicates whether the zone map has been marked unusable by the owner (YES) or not (NO)
COMPILE_STATE VARCHAR2(19)   Current compile state of the zone map:
  • VALID

  • AUTHORIZATION_ERROR

  • COMPILATION_ERROR

  • NEEDS_COMPILE

  • ERROR_UNKNOWN

Similar to ALL_MVIEWS.COMPILE_STATE.


Note:

This view is available starting with Oracle Database 12c Release 1 (12.1.0.2).

See Also: