DBA Data[Home] [Help]

VIEW: SYS.KU$_ZM_VIEW_VIEW

Source

View Text - Preformatted

select * from ku$_m_view_view_base b
  where  bitand(b.flag2,33554432) = 33554432      /* secondary mviews. */
     and (bitand(b.flag3, 512) = 0                /* snapshot != zonemap */
      or bitand(b.xpflags, 34359738368) = 0)      /* summary != zonemap */
View Text - HTML Formatted

SELECT *
FROM KU$_M_VIEW_VIEW_BASE B
WHERE BITAND(B.FLAG2
, 33554432) = 33554432 /* SECONDARY MVIEWS. */
AND (BITAND(B.FLAG3
, 512) = 0 /* SNAPSHOT != ZONEMAP */ OR BITAND(B.XPFLAGS
, 34359738368) = 0) /* SUMMARY != ZONEMAP */