VIEW: SYS.INT$DBA_HIST_DATAFILE

Source

View Text - Preformatted

select d.dbid, d.file#, d.creation_change#,
       d.filename, d.ts#, coalesce(t.tsname, d.tsname) tsname, d.block_size,
       decode(d.con_dbid, 0, d.dbid, d.con_dbid),
       con_dbid_to_id(decode(d.con_dbid, 0, d.dbid, d.con_dbid)) con_id
from WRH$_DATAFILE d LEFT OUTER JOIN WRH$_TABLESPACE t
     on (d.dbid = t.dbid
         and d.ts# = t.ts#
         and d.con_dbid = t.con_dbid)

View Text - HTML Formatted

SELECT D.DBID
, D.FILE#
, D.CREATION_CHANGE#
, D.FILENAME
, D.TS#
, COALESCE(T.TSNAME
, D.TSNAME) TSNAME
, D.BLOCK_SIZE
, DECODE(D.CON_DBID
, 0
, D.DBID
, D.CON_DBID)
, CON_DBID_TO_ID(DECODE(D.CON_DBID
, 0
, D.DBID
, D.CON_DBID)) CON_ID FROM WRH$_DATAFILE D LEFT OUTER JOIN WRH$_TABLESPACE T ON (D.DBID = T.DBID
AND D.TS# = T.TS#
AND D.CON_DBID = T.CON_DBID)