DBA Data[Home] [Help]

VIEW: SYS.ALL_FILE_GROUP_TABLES

Source

View Text - Preformatted

select file_group_owner, file_group_name, version_name, version_id,
       owner, table_name, tablespace_name, scn
from "_ALL_FILE_GROUP_TABLES"
View Text - HTML Formatted

SELECT FILE_GROUP_OWNER
, FILE_GROUP_NAME
, VERSION_NAME
, VERSION_ID
, OWNER
, TABLE_NAME
, TABLESPACE_NAME
, SCN FROM "_ALL_FILE_GROUP_TABLES"