DBA Data[Home] [Help]

SYS.DBMS_FEATURE_PARTITION_SYSTEM dependencies on INDSUBPART$

Line 92: from indsubpart$ isp, indcompart$ icp

88: where tcp.obj# = tsp.pobj#
89: group by tcp.bo#
90: union all
91: select /* NO_MERGE FULL(isp) FULL(icp) */ icp.bo#, count(*) numsubpart
92: from indsubpart$ isp, indcompart$ icp
93: where icp.obj# = isp.pobj#
94: group by icp.bo#) osp,
95: -- real partition count for tables and indexes
96: ( select tp.bo#, count(*) xnumpart

Line 134: from indsubpart$ isp, indcompart$ icp

130: -- number or subpartitions with indexing off
131: sum(decode(bitand(isp.flags, 1), 1, 1, 0)) isp_idx_off,
132: -- number or subpartitions with deferred segment creation
133: sum(decode(bitand(isp.flags, 65536), 65536, 1, 0)) isp_seg_off
134: from indsubpart$ isp, indcompart$ icp
135: where icp.obj# = isp.pobj#
136: group by icp.bo#) ispd,
137: -- attribute clustering
138: ( select c.clstobj#, 'Y-'||