|
FILE_NAME |
VARCHAR2(513) |
|
Name of the database file |
|
FILE_ID |
NUMBER |
NOT NULL |
ID of the database file |
|
TABLESPACE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the tablespace to which the file belongs |
|
BYTES |
NUMBER |
|
Size of the file in bytes |
|
BLOCKS |
NUMBER |
NOT NULL |
Size of the file in Oracle blocks |
|
STATUS |
VARCHAR2(9) |
|
File status: AVAILABLE or INVALID (INVALID means that the file number is not in use, for example, a file in a tablespace that was dropped) |
|
RELATIVE_FNO |
NUMBER |
|
Relative file number |
|
AUTOEXTENSIBLE |
VARCHAR2(3) |
|
Autoextensible indicator |
|
MAXBYTES |
NUMBER |
|
Maximum file size in bytes |
|
MAXBLOCKS |
NUMBER |
|
Maximum file size in blocks |
|
INCREMENT_BY |
NUMBER |
|
Autoextension increment |
|
USER_BYTES |
NUMBER |
|
Corresponding number of bytes |
|
USER_BLOCKS |
NUMBER |
|
Number of blocks which can be used by the data |
