select g.file_group_name, v.version_name, v.version_id,
i.export_version, i.export_platform, i.export_time, i.export_scn,
i.source_db_name
from "_USER_FILE_GROUPS" g, sys.fgr$_file_group_export_info i,
sys.fgr$_file_group_versions v
where i.version_guid = v.version_guid and v.file_group_id = g.file_group_id
SELECT G.FILE_GROUP_NAME
, V.VERSION_NAME
, V.VERSION_ID
,
I.EXPORT_VERSION
, I.EXPORT_PLATFORM
, I.EXPORT_TIME
, I.EXPORT_SCN
,
I.SOURCE_DB_NAME
FROM "_USER_FILE_GROUPS" G
, SYS.FGR$_FILE_GROUP_EXPORT_INFO I
,
SYS.FGR$_FILE_GROUP_VERSIONS V
WHERE I.VERSION_GUID = V.VERSION_GUID
AND V.FILE_GROUP_ID = G.FILE_GROUP_ID
|
|
|