select g.file_group_owner, g.file_group_name, v.version_name, v.version_id,
ti.version_guid, ti.schema_name, ti.table_name, ti.tablespace_name,
ti.scn
from "_ALL_FILE_GROUPS" g, sys.fgr$_table_info ti,
sys.fgr$_file_group_versions v
where ti.version_guid = v.version_guid and v.file_group_id = g.file_group_id
SELECT G.FILE_GROUP_OWNER
, G.FILE_GROUP_NAME
, V.VERSION_NAME
, V.VERSION_ID
,
TI.VERSION_GUID
, TI.SCHEMA_NAME
, TI.TABLE_NAME
, TI.TABLESPACE_NAME
,
TI.SCN
FROM "_ALL_FILE_GROUPS" G
, SYS.FGR$_TABLE_INFO TI
,
SYS.FGR$_FILE_GROUP_VERSIONS V
WHERE TI.VERSION_GUID = V.VERSION_GUID
AND V.FILE_GROUP_ID = G.FILE_GROUP_ID
|
|
|