eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

SYS.DBMS_FEATURE_PARTITION_USER 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 196: -- fix bug 3074607 - filter on obj$

192: and o.obj# = attrcl.clstobj#(+)
193: and o.obj# = zm.detailobj#(+)
194: -- bug 14369338, exclude AUDSYS
195: and u.name not in ('SYS','SYSTEM','SH','SYSMAN','AUDSYS')
196: -- fix bug 3074607 - filter on obj$
197: and o.type# in (1,2,19,20,25,34,35)
198: -- exclude flashback data archive tables
199: -- fix bug 14666795
200: and o.name not like 'SYS_FBA%'

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

227: decode(bitand(i.flags, 8388608), 8388608, 'PARTIAL', 'FULL') PARTIAL_IDX,
228: decode(bitand(i.flags, 268435456), 268435456, 'YES', 'NO') ORPHANED_ENTRIES,
229: NULL ZONEMAP, NULL ATTRCLUSTER,
230: NULL SUBPARTEMP
231: from partobj$ p, user$ u, obj$ o, ind$ i
232: where p.obj# = i.bo#
233: -- exclude global nonpartitioned indexes on change tables
234: and i.bo# not in ( select obj# from cdc_change_tables$)
235: -- exclude flashback data archive tables