ALL_FILE_GROUP_EXPORT_INFO shows export-related information for each version accessible to the current user. There will only be information in this view for versions that have a valid Data Pump dump file.
DBA_FILE_GROUP_EXPORT_INFO shows export-related information for each version in the database that has a valid Data Pump dump file.
USER_FILE_GROUP_EXPORT_INFO shows export-related 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 |
EXPORT_VERSION |
VARCHAR2(30) |
NOT NULL |
Version of exported objects |
PLATFORM_NAME |
VARCHAR2(101) |
NOT NULL |
Platform on which the export was performed |
EXPORT_TIME |
DATE |
NOT NULL |
Time at which the export job was performed |
EXPORT_SCN |
NUMBER |
SCN of the export job | |
SOURCE_GLOBAL_NAME |
VARCHAR2(128) |
Global name of the exporting database |