|
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 |
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 |
|
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 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) |
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. |
|
BLOCK1_OFFSET |
NUMBER |
The 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) |
The auxiliary name that has been set for this file via CONFIGURE AUXNAME |
