DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.USER_FILE_GROUP_TABLESPACES

Object Details
Object Name: USER_FILE_GROUP_TABLESPACES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Details about the transportable tablespaces in the file group repository

[View Source]

Columns
Name Datatype Length Mandatory Comments
FILE_GROUP_NAME VARCHAR2 (128) Yes Name of the file group
VERSION_NAME VARCHAR2 (128) Yes Name of the version
VERSION NUMBER
Yes Internal version number
TABLESPACE_NAME VARCHAR2 (30) Yes Name of the tablespace
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FILE_GROUP_NAME
,      VERSION_NAME
,      VERSION
,      TABLESPACE_NAME
FROM SYS.USER_FILE_GROUP_TABLESPACES;

Dependencies

[top of page]

SYS.USER_FILE_GROUP_TABLESPACES references the following:

SchemaSYS
TableFGR$_FILE_GROUP_VERSIONS
TableFGR$_TABLESPACE_INFO
View_USER_FILE_GROUPS
SYS.USER_FILE_GROUP_TABLESPACES is referenced by following:

SchemaPUBLIC
SynonymUSER_FILE_GROUP_TABLESPACES