DBA Data[Home] [Help]

VIEW: SYS.DBA_HIST_DATAFILE

Source

View Text - Preformatted

select "DBID","FILE#","CREATION_CHANGE#","FILENAME","TS#","TSNAME","BLOCK_SIZE","CON_DBID","CON_ID" from INT$DBA_HIST_DATAFILE
View Text - HTML Formatted

SELECT "DBID"
, "FILE#"
, "CREATION_CHANGE#"
, "FILENAME"
, "TS#"
, "TSNAME"
, "BLOCK_SIZE"
, "CON_DBID"
, "CON_ID"
FROM INT$DBA_HIST_DATAFILE