| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 | 
 | 
| 
 | PDF · Mobi · ePub | 
ALL_FILE_GROUP_TABLES shows information about the tables accessible to the current user that can be imported using the file set.
DBA_FILE_GROUP_TABLES shows information about all the tables in the database that can be imported using the file set.
USER_FILE_GROUP_TABLES shows information about tables owned by the current user that can be imported using the file set. 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 | Version of the file group that contains the table | 
| VERSION | NUMBER | NOT NULL | Internal version number | 
| OWNER | VARCHAR2(30) | NOT NULL | Schema to which the table belongs | 
| TABLE_NAME | VARCHAR2(30) | NOT NULL | Name of the table | 
| TABLESPACE_NAME | VARCHAR2(30) | Name of the tablespace to which the table belongs | |
| SCN | NUMBER | SCN at which the table was exported (available only for Streams-prepared tables) |