FILE# |
NUMBER |
File identification number |
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 |
STATUS |
VARCHAR2(7) |
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 |
Timestamp 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 |
Timestamp of the last unrecoverable change |
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 |
BYTES |
NUMBER |
Current datafile size (in bytes); 0 if inaccessible |
BLOCKS |
NUMBER |
Current datafile size (in blocks); 0 if inaccessible |
CREATE_BYTES |
NUMBER |
Size when created (in bytes) |
BLOCK_SIZE |
NUMBER |
Block size of the datafile |
NAME |
VARCHAR2(513) |
Name of the datafile |
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. |
BLOCK1_OFFSET |
NUMBER |
Offset from the beginning of the file to where the Oracle generic information begins. The exact length of the file can be computed as follows: BYTES + BLOCK1_OFFSET . |
AUX_NAME |
VARCHAR2(513) |
Auxiliary name that has been set for this file via CONFIGURE AUXNAME |