ALL_FILE_GROUPS shows top-level metadata about the file groups accessible to the current user.
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(30) |
NOT NULL |
Owner of the file group |
FILE_GROUP_NAME |
VARCHAR2(30) |
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(30) |
Name of the default directory object |