ALL_FILE_GROUP_FILES shows the file set for each versioned file group accessible to the current user.
DBA_FILE_GROUP_FILES shows the file set for each versioned group in the database.
USER_FILE_GROUP_FILES shows the file set for each versioned group owned by the current user. This view does not display the FILE_GROUP_OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
FILE_GROUP_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the file group |
FILE_GROUP_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the file group |
VERSION_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the version to which the file belongs |
VERSION |
NUMBER |
NOT NULL |
Internal version number of the file group version to which the file belongs |
FILE_NAME |
VARCHAR2(512) |
NOT NULL |
Name of the file |
FILE_DIRECTORY |
VARCHAR2(30) |
NOT NULL |
Directory object for the directory where the file is stored |
FILE_TYPE |
VARCHAR2(32) |
User-specified file type | |
FILE_SIZE |
NUMBER |
Size of the file | |
FILE_BLOCK_SIZE |
NUMBER |
Block size for the file | |
COMMENTS |
VARCHAR2(4000) |
Comments about the file group |