VIEW: SYS.USER_ZONEMAPS

Source

View Text - Preformatted

select z."OWNER",z."ZONEMAP_NAME",z."FACT_OWNER",z."FACT_TABLE",z."SCALE",z."HIERARCHICAL",z."WITH_CLUSTERING",z."QUERY",z."QUERY_LEN",z."PRUNING",z."REFRESH_MODE",z."REFRESH_METHOD",z."LAST_REFRESH_METHOD",z."LAST_REFRESH_TIME",z."INVALID",z."STALE",z."UNUSABLE",z."COMPILE_STATE" from dba_zonemaps z, sys.user$ u
where u.user# = userenv('SCHEMAID')
  and z.owner = u.name

View Text - HTML Formatted

SELECT Z."OWNER"
, Z."ZONEMAP_NAME"
, Z."FACT_OWNER"
, Z."FACT_TABLE"
, Z."SCALE"
, Z."HIERARCHICAL"
, Z."WITH_CLUSTERING"
, Z."QUERY"
, Z."QUERY_LEN"
, Z."PRUNING"
, Z."REFRESH_MODE"
, Z."REFRESH_METHOD"
, Z."LAST_REFRESH_METHOD"
, Z."LAST_REFRESH_TIME"
, Z."INVALID"
, Z."STALE"
, Z."UNUSABLE"
, Z."COMPILE_STATE"
FROM DBA_ZONEMAPS Z
, SYS.USER$ U WHERE U.USER# = USERENV('SCHEMAID')
AND Z.OWNER = U.NAME