DBA Data[Home] [Help]

SYS.DBMS_FEATURE_PARTITION_USER dependencies on INDPART$

Line 101: from indpart$ ip

97: from tabpart$ tp
98: group by tp.bo#
99: union all
100: select ip.bo#, count(*) xnumpart
101: from indpart$ ip
102: group by ip.bo#) op,
103: -- details table partitions: partial indexing and deferred segments
104: ( select tp.bo#,
105: -- number or partitions with indexing off

Line 126: from indpart$ ip

122: -- number or partitions with indexing off
123: sum(decode(bitand(ip.flags, 1), 1, 1, 0)) ip_idx_off,
124: -- number or partitions with deferred segment creation
125: sum(decode(bitand(ip.flags, 65536), 65536, 1, 0)) ip_seg_off
126: from indpart$ ip
127: group by ip.bo#) ipd,
128: -- details index subpartitions: partial indexing and deferred segments
129: ( select icp.bo#,
130: -- number or subpartitions with indexing off