FILE#

NUMBER

The absolute file number

CREATION_CHANGE#

NUMBER

The creation System Change Number (SCN)

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