2.144 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 theFILE_GROUP_OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the file group |
|
|
|
Name of the file group |
|
|
|
A value of Y or N to indicate whether or not files should be deleted when a version is purged |
|
|
|
Autopurge should not drop a version if this condition will become violated |
|
|
|
Autopurge will drop the oldest version when this condition is violated |
|
|
|
Autopurge will drop versions older than this if doing so does not violate |
|
|
|
Time at which the file group was created |
|
|
|
Comments about the file group |
|
|
|
Name of the default directory object |
See Also: