2.143 ALL_FILE_GROUP_TABLES
ALL_FILE_GROUP_TABLES
shows information about the tables accessible to the current user that can be imported using the file set.
Related Views
-
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 theFILE_GROUP_OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the file group |
|
|
|
Name of the file group |
|
|
|
Version of the file group that contains the table |
|
|
|
Internal version number |
|
|
|
Schema to which the table belongs |
|
|
|
Name of the table |
|
|
|
Name of the tablespace to which the table belongs |
|
|
|
SCN at which the table was exported (available only for Streams-prepared tables) |
See Also: