ALL_FILE_GROUP_TABLESPACES shows information about the transportable tablespaces present (partially or completely) in the file groups accessible to the current user (when the file groups contain dump files).
DBA_FILE_GROUP_TABLESPACES shows information about the transportable tablespaces present (partially or completely) in all file groups in the database (when the file groups contain dump files).
USER_FILE_GROUP_TABLESPACES shows information about the transportable tablespaces present (partially or completely) in the file groups owned by the current user (when the file groups contain dump files). 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 tablespace |
VERSION |
NUMBER |
NOT NULL |
Internal version number |
TABLESPACE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the tablespace |