Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
ALL_FILE_GROUP_VERSIONS
shows top-level version information for the file groups accessible to the current user.
DBA_FILE_GROUP_VERSIONS
shows top-level version information for all file groups in the database.
USER_FILE_GROUP_VERSIONS
shows top-level version information for all 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 |
VERSION_NAME |
VARCHAR2(30) |
NOT NULL |
User-specified name for the version |
VERSION |
NUMBER |
NOT NULL |
Internal version number |
CREATOR |
VARCHAR2(30) |
NOT NULL |
User who created the version |
CREATED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
Time at which the version was created |
COMMENTS |
VARCHAR2(4000) |
Comments about the file group | |
DEFAULT_DIRECTORY |
VARCHAR2(30) |
Default directory object for this version, if specified |