FILE# |
NUMBER |
File identification number |
STATUS |
VARCHAR2 |
Type of file (system or user) and its status. Values: OFFLINE , ONLINE , SYSTEM , RECOVER , SYSOFF (an offline file from the SYSTEM tablespace) |
ENABLED |
VARCHAR2(10) |
Describes how accessible the file is from SQL:
DISABLED : No SQL access allowed
READ ONLY : No SQL updates allowed
READ WRITE : Full access allowed
UNKNOWN : Should not occur unless the control file is corrupted.
|
CHECKPOINT_CHANGE# |
NUMBER |
SCN at last checkpoint |
CHECKPOINT_TIME |
DATE |
Time stamp of the checkpoint# |
UNRECOVERABLE _CHANGE# |
NUMBER |
Last unrecoverable change# made to this datafile. This column is always updated when an unrecoverable operation completes |
UNRECOVERABLE_TIME |
DATE |
Time stamp of the last unrecoverable change |
BYTES |
NUMBER |
Current size in bytes; 0 if inaccessible |
CREATE_BYTES |
NUMBER |
Size when created, in bytes |
NAME |
VARCHAR2 |
Name of the file |
CREATION_CHANGE# |
NUMBER |
Change number at which the datafile was created |
CREATION_TIME |
DATE |
Timestamp of the datafile creation |
TS# |
NUMBER |
Tablespace number |
RFILE# |
NUMBER |
Tablespace relative datafile number |
LAST_CHANGE# |
NUMBER |
Last change# made to this datafile. Set to NULL if the datafile is being changed |
LAST_TIME |
DATE |
Timestamp of the last change |
OFFLINE_CHANGE# |
NUMBER |
Offline change# of the last offline range. This column is updated only when the datafile is brought online |
ONLINE_CHANGE# |
NUMBER |
Online change# of the last offline range |
ONLINE_TIME |
DATE |
Online timestamp of the last offline range |
BLOCKS |
NUMBER |
Current datafile size in blocks; 0 if inaccessible |
BLOCK_SIZE |
NUMBER |
Block size of the datafile |
NAME |
VARCHAR2(512) |
Datafile name |
PLUGGED_IN |
NUMBER |
Describes whether the tablespace is plugged in. The value is 1 if the tablespace is plugged in and has not been made read-write, 0 if not. |