ALL_FILE_GROUPS

ALL_FILE_GROUPS shows top-level metadata about the file groups accessible to the current user.

Related Views

DBA_FILE_GROUPS shows top-level metadata about all file groups in the database.
USER_FILE_GROUPS shows top-level metadata about file groups 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
`KEEP_FILES`	`VARCHAR2(1)`	`NOT NULL`	A value of Y or N to indicate whether or not files should be deleted when a version is purged
`MIN_VERSIONS`	`NUMBER`	`NOT NULL`	Autopurge should not drop a version if this condition will become violated
`MAX_VERSIONS`	`NUMBER`	`NOT NULL`	Autopurge will drop the oldest version when this condition is violated
`RETENTION_DAYS`	`NUMBER`	`NOT NULL`	Autopurge will drop versions older than this if doing so does not violate `MIN_VERSIONS`
`CREATED`	`TIMESTAMP(6) WITH TIME ZONE`	`NOT NULL`	Time at which the file group was created
`COMMENTS`	`VARCHAR2(4000)`		Comments about the file group
`DEFAULT_DIRECTORY`	`VARCHAR2(128)`		Name of the default directory object