DBA Data[Home] [Help]

SYS.DBMS_FEATURE_PARTITION_SYSTEM dependencies on USER$

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