SYS.DBMS_FEATURE_PARTITION_USER dependencies on TABPART$

Line 97: from tabpart$ tp

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
97: from tabpart$ tp
98: group by tp.bo#
99: union all
100: select ip.bo#, count(*) xnumpart
101: from indpart$ ip

Line 109: from tabpart$ tp

105: -- number or partitions with indexing off
106: sum(decode(bitand(tp.flags, 2097152), 2097152, 1, 0)) tp_idx_off,
107: -- number or partitions with deferred segment creation
108: sum(decode(bitand(tp.flags, 65536), 65536, 1, 0)) tp_seg_off
109: from tabpart$ tp
110: group by tp.bo#) pxd,
111: -- details table subpartitions: partial indexing and deferred segments
112: ( select tcp.bo#,
113: -- number or subpartitions with indexing off

Line 261: from tabpart$ p, seg$ s

257: SELECT c1, TRUNC((ratio_to_report(sum_blocks) over())*100,2) pcnt
258: FROM
259: (
260: select decode(p.obj#,null,'REST','PARTTAB') c1, sum(s.blocks) sum_blocks
261: from tabpart$ p, seg$ s
262: where s.file#=p.file#(+)
263: and s.block#=p.block#(+)
264: and s.type#=5
265: group by decode(p.obj#,null,'REST','PARTTAB')