DBA Data[Home] [Help]

SYS.DBMS_FEATURE_PARTITION_USER dependencies on SEG$

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')