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.

[Home] [Help]

VIEW: SYS.EXT_TO_OBJ_VIEW

Source

View Text - Preformatted


select file$.file# file#
       , uet$.block# lowb
       , uet$.block# + uet$.length - 1 highb
       , obj$.name name
       , NULL partition_name
       , 'TABLE' kind
       , owner#
  from tab$, uet$, obj$, file$
  where bitand(tab$.property, 1024) = 0          /* exclude clustered tables */
    and tab$.file# = uet$.segfile#
    and tab$.block# = uet$.segblock#
    and tab$.ts# = uet$.ts#
    and tab$.obj# = obj$.obj#
    and file$.ts# = uet$.ts#
    and file$.relfile# = uet$.file#
union all
  select file$.file# file#
       , uet$.block# lowb
       , uet$.block# + uet$.length - 1 highb
       , obj$.name name
       , obj$.subname partition_name
       , 'TABLE PARTITION' kind
       , owner#
  from tabpart$, uet$, obj$, file$
  where tabpart$.file# = uet$.segfile#
    and tabpart$.block# = uet$.segblock#
    and tabpart$.ts# = uet$.ts#
    and tabpart$.obj# = obj$.obj#
    and file$.ts# = uet$.ts#
    and file$.relfile# = uet$.file#
union all
  select distinct
         file$.file# file#
       , uet$.block# lowb
       , uet$.block# + uet$.length - 1 highb
       , obj$.name name
       , NULL partition_name
       , 'CLUSTER' kind
       , owner#
  from tab$, uet$, obj$, file$
  where bitand(tab$.property, 1024) = 1024               /* clustered tables */
    and tab$.file# = uet$.segfile#
    and tab$.block# = uet$.segblock#
    and tab$.ts# = uet$.ts#
    and tab$.bobj# = obj$.obj#
    and file$.ts# = uet$.ts#
    and file$.relfile# = uet$.file#
union all
  select file$.file# file#
       , uet$.block# lowb
       , uet$.block# + uet$.length - 1 highb
       , obj$.name name
       , NULL artition_name
       , 'INDEX' kind
       , owner#
  from ind$, uet$, obj$, file$
  where ind$.file# = uet$.segfile#
    and ind$.block# = uet$.segblock#
    and ind$.ts# = uet$.ts#
    and ind$.obj# = obj$.obj#
    and file$.ts# = uet$.ts#
    and file$.relfile# = uet$.file#
union all
  select file$.file# file#
       , uet$.block# lowb
       , uet$.block# + uet$.length - 1 highb
       , obj$.name name
       , obj$.subname partition_name
       , 'INDEX PARTITION' kind
       , owner#
  from indpart$, uet$, obj$, file$
  where indpart$.file# = uet$.segfile#
    and indpart$.block# = uet$.segblock#
    and indpart$.ts# = uet$.ts#
    and indpart$.obj# = obj$.obj#
    and file$.ts# = uet$.ts#
    and file$.relfile# = uet$.file#
union all
  select file$.file# file#
       , uet$.block# lowb
       , uet$.block# + uet$.length - 1 highb
       , undo$.name name
       , NULL partition_name
       , 'UNDO' kind
       , user# owner#
  from undo$, uet$, file$
  where undo$.file# = uet$.segfile#
    and undo$.block# = uet$.segblock#
    and undo$.ts# = uet$.ts#
    and file$.ts# = uet$.ts#
    and file$.relfile# = uet$.file#
union all
  select file$.file# file#
       , uet$.block# lowb
       , uet$.block# + uet$.length - 1 highb
       , 'TEMP SEGMENT' name
       , NULL partition_name
       , 'TEMP SEGMENT' kind
       , 1 owner#
  from uet$, seg$, file$
  where seg$.file# = uet$.segfile#
   and  seg$.block# = uet$.block#
   and  seg$.ts# = uet$.ts#
   and  seg$.type# = 3
   and file$.ts# = uet$.ts#
   and file$.relfile# = uet$.file#
union all
  select file$.file#
       , fet$.block#
       , fet$.length + fet$.block# - 1
       , 'FREE EXTENT' name
       , NULL partition_name
       , 'FREE EXTENT' kind
       , 1  owner#
  from fet$, file$
  where file$.ts# = fet$.ts#
    and file$.relfile# = fet$.file#

View Text - HTML Formatted

SELECT FILE$.FILE# FILE#
, UET$.BLOCK# LOWB
, UET$.BLOCK# + UET$.LENGTH - 1 HIGHB
, OBJ$.NAME NAME
, NULL PARTITION_NAME
, 'TABLE' KIND
, OWNER#
FROM TAB$
, UET$
, OBJ$
, FILE$
WHERE BITAND(TAB$.PROPERTY
, 1024) = 0 /* EXCLUDE CLUSTERED TABLES */
AND TAB$.FILE# = UET$.SEGFILE#
AND TAB$.BLOCK# = UET$.SEGBLOCK#
AND TAB$.TS# = UET$.TS#
AND TAB$.OBJ# = OBJ$.OBJ#
AND FILE$.TS# = UET$.TS#
AND FILE$.RELFILE# = UET$.FILE# UNION ALL SELECT FILE$.FILE# FILE#
, UET$.BLOCK# LOWB
, UET$.BLOCK# + UET$.LENGTH - 1 HIGHB
, OBJ$.NAME NAME
, OBJ$.SUBNAME PARTITION_NAME
, 'TABLE PARTITION' KIND
, OWNER#
FROM TABPART$
, UET$
, OBJ$
, FILE$
WHERE TABPART$.FILE# = UET$.SEGFILE#
AND TABPART$.BLOCK# = UET$.SEGBLOCK#
AND TABPART$.TS# = UET$.TS#
AND TABPART$.OBJ# = OBJ$.OBJ#
AND FILE$.TS# = UET$.TS#
AND FILE$.RELFILE# = UET$.FILE# UNION ALL SELECT DISTINCT FILE$.FILE# FILE#
, UET$.BLOCK# LOWB
, UET$.BLOCK# + UET$.LENGTH - 1 HIGHB
, OBJ$.NAME NAME
, NULL PARTITION_NAME
, 'CLUSTER' KIND
, OWNER#
FROM TAB$
, UET$
, OBJ$
, FILE$
WHERE BITAND(TAB$.PROPERTY
, 1024) = 1024 /* CLUSTERED TABLES */
AND TAB$.FILE# = UET$.SEGFILE#
AND TAB$.BLOCK# = UET$.SEGBLOCK#
AND TAB$.TS# = UET$.TS#
AND TAB$.BOBJ# = OBJ$.OBJ#
AND FILE$.TS# = UET$.TS#
AND FILE$.RELFILE# = UET$.FILE# UNION ALL SELECT FILE$.FILE# FILE#
, UET$.BLOCK# LOWB
, UET$.BLOCK# + UET$.LENGTH - 1 HIGHB
, OBJ$.NAME NAME
, NULL ARTITION_NAME
, 'INDEX' KIND
, OWNER#
FROM IND$
, UET$
, OBJ$
, FILE$
WHERE IND$.FILE# = UET$.SEGFILE#
AND IND$.BLOCK# = UET$.SEGBLOCK#
AND IND$.TS# = UET$.TS#
AND IND$.OBJ# = OBJ$.OBJ#
AND FILE$.TS# = UET$.TS#
AND FILE$.RELFILE# = UET$.FILE# UNION ALL SELECT FILE$.FILE# FILE#
, UET$.BLOCK# LOWB
, UET$.BLOCK# + UET$.LENGTH - 1 HIGHB
, OBJ$.NAME NAME
, OBJ$.SUBNAME PARTITION_NAME
, 'INDEX PARTITION' KIND
, OWNER#
FROM INDPART$
, UET$
, OBJ$
, FILE$
WHERE INDPART$.FILE# = UET$.SEGFILE#
AND INDPART$.BLOCK# = UET$.SEGBLOCK#
AND INDPART$.TS# = UET$.TS#
AND INDPART$.OBJ# = OBJ$.OBJ#
AND FILE$.TS# = UET$.TS#
AND FILE$.RELFILE# = UET$.FILE# UNION ALL SELECT FILE$.FILE# FILE#
, UET$.BLOCK# LOWB
, UET$.BLOCK# + UET$.LENGTH - 1 HIGHB
, UNDO$.NAME NAME
, NULL PARTITION_NAME
, 'UNDO' KIND
, USER# OWNER#
FROM UNDO$
, UET$
, FILE$
WHERE UNDO$.FILE# = UET$.SEGFILE#
AND UNDO$.BLOCK# = UET$.SEGBLOCK#
AND UNDO$.TS# = UET$.TS#
AND FILE$.TS# = UET$.TS#
AND FILE$.RELFILE# = UET$.FILE# UNION ALL SELECT FILE$.FILE# FILE#
, UET$.BLOCK# LOWB
, UET$.BLOCK# + UET$.LENGTH - 1 HIGHB
, 'TEMP SEGMENT' NAME
, NULL PARTITION_NAME
, 'TEMP SEGMENT' KIND
, 1 OWNER#
FROM UET$
, SEG$
, FILE$
WHERE SEG$.FILE# = UET$.SEGFILE#
AND SEG$.BLOCK# = UET$.BLOCK#
AND SEG$.TS# = UET$.TS#
AND SEG$.TYPE# = 3
AND FILE$.TS# = UET$.TS#
AND FILE$.RELFILE# = UET$.FILE# UNION ALL SELECT FILE$.FILE#
, FET$.BLOCK#
, FET$.LENGTH + FET$.BLOCK# - 1
, 'FREE EXTENT' NAME
, NULL PARTITION_NAME
, 'FREE EXTENT' KIND
, 1 OWNER#
FROM FET$
, FILE$
WHERE FILE$.TS# = FET$.TS#
AND FILE$.RELFILE# = FET$.FILE#