VIEW: SYS.KU$_CLST_ZONEMAP_VIEW

Source

View Text - Preformatted

select o.obj#, s.sowner, s.tname
  from obj$ o, user$ u, snap$ s
  where o.owner# = u.user#
    and s.mowner = u.name
    and s.master = o.name
    and bitand(s.flag3, 512) = 512                     /* snapshot = zonemap */

View Text - HTML Formatted

SELECT O.OBJ#
, S.SOWNER
, S.TNAME
FROM OBJ$ O
, USER$ U
, SNAP$ S
WHERE O.OWNER# = U.USER#
AND S.MOWNER = U.NAME
AND S.MASTER = O.NAME
AND BITAND(S.FLAG3
, 512) = 512 /* SNAPSHOT = ZONEMAP */