FILE# 

NUMBER 

The absolute file number 

CREATION_CHANGE# 

NUMBER 

The creation System Change Number 

CREATION_TIME 

DATE 

The creation time 

TS# 

NUMBER 

The tablespace number 

RFILE# 

NUMBER 

The relative file number in tablespace 

STATUS 

VARCHAR2(7) 

The status of the file (offline/online) 

ENABLED 

VARCHAR2(10) 

Enabled for read and/or write 

BYTES 

NUMBER 

The size of the file in bytes (from File Header) 

BLOCKS 

NUMBER 

The size of the file in blocks (from File Header) 

CREATE_BYTES 

NUMBER 

The creation size of the file (in bytes) 

BLOCK_SIZE 

NUMBER 

The block size for the file 

NAME 

VARCHAR2(513) 

The name of the file