V$OFFLINE_RANGE

This view displays datafile offline information from the control file. Note that the last offline range of each datafile is kept in the DATAFILE record.

An offline range is created for a datafile when its tablespace is first altered to be OFFLINE NORMAL or READ ONLY, and then subsequently altered to be ONLINE or read/write. Note that no offline range is created if the datafile itself is altered to be OFFLINE or if the tablespace is altered to be OFFLINE IMMEDIATE.

See Also:

"V$DATAFILE"

Column	Datatype	Description
`RECID`	`NUMBER`	Record ID
`STAMP`	`NUMBER`	Record stamp
`FILE#`	`NUMBER`	Datafile number
`OFFLINE_CHANGE#`	`NUMBER`	SCN at which offlined
`ONLINE_CHANGE#`	`NUMBER`	SCN at which onlined
`ONLINE_TIME`	`DATE`	Time of offline SCN
`RESETLOGS_CHANGE#`	`NUMBER`	Resetlogs change number of the record
`RESETLOGS_TIME`	`DATE`	Resetlogs timestamp of the record