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 */
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 */
|
|
|