ALL_FILE_GROUP_FILES

ALL_FILE_GROUP_FILES shows the file set for each versioned file group accessible to the current user.

Related Views

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(128)`	`NOT NULL`	Owner of the file group
`FILE_GROUP_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the file group
`VERSION_NAME`	`VARCHAR2(128)`	`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(128)`	`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