VIEW: SYS.DBA_FILE_GROUP_FILES

Source

View Text - Preformatted

select u.name, o.name, v.version_name, v.version_id, f.file_name,
          f.file_dir_obj, f.file_type, f.file_size, f.file_blocksize,
          f.user_comment
from sys.obj$ o, sys.user$ u, sys.fgr$_file_group_files f,
     sys.fgr$_file_groups g, sys.fgr$_file_group_versions v
where f.version_guid = v.version_guid and v.file_group_id = g.file_group_id
      and o.owner# = u.user# and o.obj# = g.file_group_id

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, V.VERSION_NAME
, V.VERSION_ID
, F.FILE_NAME
, F.FILE_DIR_OBJ
, F.FILE_TYPE
, F.FILE_SIZE
, F.FILE_BLOCKSIZE
, F.USER_COMMENT FROM SYS.OBJ$ O
, SYS.USER$ U
, SYS.FGR$_FILE_GROUP_FILES F
, SYS.FGR$_FILE_GROUPS G
, SYS.FGR$_FILE_GROUP_VERSIONS V WHERE F.VERSION_GUID = V.VERSION_GUID
AND V.FILE_GROUP_ID = G.FILE_GROUP_ID
AND O.OWNER# = U.USER#
AND O.OBJ# = G.FILE_GROUP_ID