DBA Data[Home] [Help]

SYS.DBMS_FEATURE_ZMAP dependencies on TAB$

Line 87: JOIN tab$ t

83: -- to accommodate either-or for zone maps or attribute clustering
84: FULL OUTER JOIN clst$ c
85: ON (zm.detailobj# = c.clstobj#)
86: ) x
87: JOIN tab$ t
88: ON (t.obj#=DECODE(x.clstobj#,NULL,x.detailobj#,x.clstobj#))
89: ) xx
90: -- needed for deferred segments and partitioned objects
91: LEFT OUTER JOIN seg$ s

Line 115: RIGHT OUTER JOIN tab$ t

111: ON (s.obj# = sd.sumobj#)
112: WHERE bitand(s.xpflags,34359738368)=34359738368
113: AND bitand(sd.flags,2) = 2
114: ) zm
115: RIGHT OUTER JOIN tab$ t
116: ON (t.obj#=zm.detailobj#);
117: END IF;
118:
119: END;