This view returns all datafiles. It's often joined with other views by the FILE_ID
field, sometimes named as FILE#
in other views.
The most relevant view fields are as follows:
FILE_ID
: A unique ID associated with the fileFILE_NAME
: The name of the database fileTABLESPACE_NAME
: The name of the tablespace to which the file belongsBYTES
: The size in bytesBLOCKS
: The size in database blocksSTATUS
: The status of the file, related to its availability; can beAVAILABLE
orINVALID
(for example, a file in a dropped tablespace)ONLINE_STATUS
: The online status of the file, can beSYSOFF
,SYSTEM
,OFFLINE
,ONLINE
, orRECOVER