FILE# |
NUMBER |
The absolute file number |
CREATION_CHANGE# |
NUMBER |
The creation System Change Number |
CREATION_TIME |
DATE |
The creation time |
TS# |
NUMBER |
The tablespace number |
RFILE# |
NUMBER |
The relative file number in tablespace |
STATUS |
VARCHAR2(7) |
The status of the file (offline/online) |
ENABLED |
VARCHAR2(10) |
Enabled for read and/or write |
BYTES |
NUMBER |
The size of the file in bytes (from File Header) |
BLOCKS |
NUMBER |
The size of the file in blocks (from File Header) |
CREATE_BYTES |
NUMBER |
The creation size of the file (in bytes) |
BLOCK_SIZE |
NUMBER |
The block size for the file |
NAME |
VARCHAR2(513) |
The name of the file |