This view lists the offline ranges for data files. It corresponds to the V$OFFLINE_RANGE view.
An offline range is created for a data file when its tablespace is first altered to be offline normal or read-only, and then subsequently altered to be online or read/write. No offline range is created if the data file itself is altered to be offline or if the tablespace is altered to be offline immediate.
| Column | Data Type | Description |
|---|---|---|
DB_KEY |
NUMBER |
The primary key for the target database. Use this column to join with almost any other catalog view. |
DBINC_KEY |
NUMBER |
The primary key for the incarnation of the target database. Use this column to join with RC_DATABASE_INCARNATION. |
DB_NAME |
VARCHAR2(8) |
The DB_NAME of the database incarnation to which this record belongs. |
RECID |
NUMBER |
The record identifier for the offline range from V$OFFLINE_RANGE. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file. |
STAMP |
NUMBER |
The stamp for the offline range from V$OFFLINE_RANGE. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file. |
FILE# |
NUMBER |
The absolute file number of the data file. |
CREATION_CHANGE# |
NUMBER |
The SCN at data file creation. |
OFFLINE_CHANGE# |
NUMBER |
The SCN taken when the data file was taken offline. |
ONLINE_CHANGE# |
NUMBER |
The online checkpoint SCN. |
ONLINE_TIME |
DATE |
The online checkpoint time. |
CF_CREATE_TIME |
DATE |
The time of control file creation. |
RESETLOGS_CHANGE# |
NUMBER |
The SCN of the most recent RESETLOGS in the data file header. |
RESETLOGS_TIME |
DATE |
The time corresponding to RESETLOGS_CHANGE#. |
OFFR_KEY |
NUMBER |