DBA Data[Home] [Help]

SYS.DBMS_FEATURE_PARTITION_SYSTEM dependencies on OBJ$

Line 83: from partobj$ p, obj$ o, user$ u, ind$ i,

79: null ORPHANED_ENTRIES,
80: decode(zonemap,null,'N',zonemap) ZONEMAP,
81: decode(attrcluster,null,'N',attrcluster) ATTRCLUSTER,
82: st_part SUBPARTEMP
83: from partobj$ p, obj$ o, user$ u, ind$ i,
84: ( select distinct obj#, 'XML-' as is_xml from opqtype$ where type=1) xml,
85: -- real subpartition count for tables and indexes
86: ( select /* NO_MERGE FULL(tsp) FULL(tcp) */ tcp.bo#, count(*) numsubpart
87: from tabsubpart$ tsp, tabcompart$ tcp

Line 194: -- fix bug 3074607 - filter on obj$

190: and p.obj# = ispd.bo#(+)
191: and p.obj# = spt.bo#(+)
192: and o.obj# = attrcl.clstobj#(+)
193: and o.obj# = zm.detailobj#(+)
194: -- fix bug 3074607 - filter on obj$
195: and o.type# in (1,2,19,20,25,34,35)
196: union all
197: -- global nonpartitioned indexes on partitioned tables
198: select o.obj#, i.bo#, p.obj# pobj#,

Line 220: from partobj$ p, user$ u, obj$ o, ind$ i

216: decode(bitand(i.flags, 8388608), 8388608, 'PARTIAL', 'FULL') PARTIAL_IDX,
217: decode(bitand(i.flags, 268435456), 268435456, 'YES', 'NO') ORPHANED_ENTRIES,
218: NULL ZONEMAP, NULL ATTRCLUSTER,
219: NULL SUBPARTEMP
220: from partobj$ p, user$ u, obj$ o, ind$ i
221: where p.obj# = i.bo#
222: and o.owner# = u.user#
223: and p.obj# = o.obj#
224: -- nonpartitioned index