|
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
|
