DBA_DATA_FILES
Information about database data filesColumns
___________________________
AUTOEXTENSIBLE
Autoextensible indicator: `YES` or `NO`
USER_BLOCKS
Size of the useful portion of file in ORACLE blocks
USER_BYTES
Size of the useful portion of file in bytes
FILE_NAME
Name of the database data file
INCREMENT_BY
Default increment for autoextension
MAXBLOCKS
Maximum size of the file in ORACLE blocks
MAXBYTES
Maximum size of the file in bytes
RELATIVE_FNO
Tablespace-relative file number
STATUS
File status: `INVALID` or `AVAILABLE`
BLOCKS
Size of the file in ORACLE blocks
BYTES
Size of the file in bytes
FILE_ID
ID of the database data file
TABLESPACE_NAME
Name of the tablespace to which the file belongs
Related Commands:
DBA_TEMP_FILES - List temporary files.
v$datafile - List data files (datafile
information from the control file)