VIEW: SYS.INT$DBA_HIST_SEG_STAT_OBJ

Source

View Text - Preformatted

select so.dbid, so.ts#, so.obj#, so.dataobj#, so.owner, so.object_name,
       so.subobject_name, so.object_type,
       coalesce(ts.tsname, tablespace_name) tablespace_name,
       so.partition_type,
       decode(so.con_dbid, 0, so.dbid, so.con_dbid),
       con_dbid_to_id(decode(so.con_dbid, 0, so.dbid, so.con_dbid)) con_id
from WRH$_SEG_STAT_OBJ so LEFT OUTER JOIN WRH$_TABLESPACE ts
     on (so.dbid = ts.dbid
         and so.ts# = ts.ts#
         and so.con_dbid = ts.con_dbid)

View Text - HTML Formatted

SELECT SO.DBID
, SO.TS#
, SO.OBJ#
, SO.DATAOBJ#
, SO.OWNER
, SO.OBJECT_NAME
, SO.SUBOBJECT_NAME
, SO.OBJECT_TYPE
, COALESCE(TS.TSNAME
, TABLESPACE_NAME) TABLESPACE_NAME
, SO.PARTITION_TYPE
, DECODE(SO.CON_DBID
, 0
, SO.DBID
, SO.CON_DBID)
, CON_DBID_TO_ID(DECODE(SO.CON_DBID
, 0
, SO.DBID
, SO.CON_DBID)) CON_ID FROM WRH$_SEG_STAT_OBJ SO LEFT OUTER JOIN WRH$_TABLESPACE TS ON (SO.DBID = TS.DBID
AND SO.TS# = TS.TS#
AND SO.CON_DBID = TS.CON_DBID)