[Home] [Help]
[Dependency Information]
VIEW: SYS._ALL_FILE_GROUP_TABLESPACES
Object Details
Object Name: | _ALL_FILE_GROUP_TABLESPACES |
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
FILE_GROUP_OWNER |
VARCHAR2 |
(128) |
Yes |
|
FILE_GROUP_NAME |
VARCHAR2 |
(128) |
Yes |
|
VERSION_NAME |
VARCHAR2 |
(128) |
Yes |
|
VERSION_ID |
NUMBER |
|
Yes |
|
VERSION_GUID |
RAW |
(16) |
Yes |
|
TABLESPACE_NAME |
VARCHAR2 |
(30) |
Yes |
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT FILE_GROUP_OWNER
, FILE_GROUP_NAME
, VERSION_NAME
, VERSION_ID
, VERSION_GUID
, TABLESPACE_NAME
FROM SYS._ALL_FILE_GROUP_TABLESPACES;
Dependencies
[top of page]
SYS._ALL_FILE_GROUP_TABLESPACES references the following:
-
SYS
-
FGR$_FILE_GROUP_VERSIONS
-
FGR$_TABLESPACE_INFO
-
_ALL_FILE_GROUPS
SYS._ALL_FILE_GROUP_TABLESPACES is referenced by following:
-
SYS
-
ALL_FILE_GROUP_TABLESPACES
-
DBMS_FILE_GROUP_EXP
- show dependent code