[Home] [Help] [Dependency Information]
Object Name: | CDB_ZONEMAPS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All zonemaps in the database in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Zonemap owner name | |
ZONEMAP_NAME | VARCHAR2 | (128) | Zonemap name | |
FACT_OWNER | VARCHAR2 | (128) | Fact table owner name | |
FACT_TABLE | VARCHAR2 | (128) | Fact table name | |
SCALE | NUMBER | Zonemap scale factor | ||
HIERARCHICAL | VARCHAR2 | (12) | Zonemap is hierarchical or not | |
WITH_CLUSTERING | VARCHAR2 | (15) | Is zonemap created with clustering clause | |
QUERY_LEN | NUMBER | Zonemap defining query length | ||
PRUNING | VARCHAR2 | (8) | Zonemap enabled for pruning or not | |
REFRESH_MODE | VARCHAR2 | (17) | Refresh on: commit/demand/load/datamovement | |
REFRESH_METHOD | VARCHAR2 | (14) | Refresh method: force/complete/fast | |
LAST_REFRESH_METHOD | VARCHAR2 | (19) | Refresh method used last time | |
LAST_REFRESH_TIME | TIMESTAMP(9) | (20) | Time last refresh occurred | |
INVALID | VARCHAR2 | (7) | Zonemap invalid (due to some DDL) or not | |
STALE | VARCHAR2 | (7) | Zonemap fully stale or not | |
UNUSABLE | VARCHAR2 | (8) | Zonemap marked unusable (by user) or not | |
COMPILE_STATE | VARCHAR2 | (19) | Zonemap compile state | |
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, ZONEMAP_NAME
, FACT_OWNER
, FACT_TABLE
, SCALE
, HIERARCHICAL
, WITH_CLUSTERING
, QUERY_LEN
, PRUNING
, REFRESH_MODE
, REFRESH_METHOD
, LAST_REFRESH_METHOD
, LAST_REFRESH_TIME
, INVALID
, STALE
, UNUSABLE
, COMPILE_STATE
, CON_ID
FROM SYS.CDB_ZONEMAPS;
SYS.CDB_ZONEMAPS does not reference any database object
SYS.CDB_ZONEMAPS is referenced by following:
|
|
|