DBA_DATA_FILES

This view returns all datafiles. It's often joined with other views by the FILE_ID field, sometimes named as FILE# in other views.

Fields

The most relevant view fields are as follows:

• FILE_ID: A unique ID associated with the file

• FILE_NAME: The name of the database file

• TABLESPACE_NAME: The name of the tablespace to which the file belongs

• BYTES: The size in bytes

• BLOCKS: The size in database blocks

• STATUS: The status of the file, related to its availability; can be AVAILABLE or INVALID (for example, a file in a dropped tablespace)

• ONLINE_STATUS: The online status of the file, can be SYSOFF, SYSTEM, OFFLINE, ONLINE, or RECOVER

See also

• The DBA_EXTENTS, FILE$, V$DATAFILE, V$LOGFILE, DBA_TEMP_FILES, and V$CONTROLFILE sections in this appendix