2.144 ALL_FILE_GROUP_TABLESPACES
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).
Related Views
-
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 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 tablespace |
|
|
|
Internal version number |
|
|
|
Name of the tablespace |
See Also: