| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
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 |
