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


TABLE: SYS.FGR$_TABLE_INFO

Object Details
Object Name: FGR$_TABLE_INFO
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
I_FGR$_TABLE_INFO1 NORMAL UNIQUE TablespaceSYSTEM ColumnVERSION_GUID
ColumnSCHEMA_NAME
ColumnTABLE_NAME
ColumnTABLESPACE_NAME
I_FGR$_TABLE_INFO2 NORMAL NONUNIQUE TablespaceSYSTEM ColumnSCHEMA_NAME
ColumnTABLE_NAME
ColumnTABLESPACE_NAME
I_FGR$_TABLE_INFO3 NORMAL NONUNIQUE TablespaceSYSTEM ColumnTABLE_NAME
Columns
Name Datatype Length Mandatory Comments
VERSION_GUID RAW (16) Yes
SCHEMA_NAME VARCHAR2 (128) Yes
TABLE_NAME VARCHAR2 (128) Yes
TABLESPACE_NAME VARCHAR2 (30)
SCN NUMBER

SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 VARCHAR2 (128)
SPARE4 VARCHAR2 (128)
Query Text

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


SELECT VERSION_GUID
,      SCHEMA_NAME
,      TABLE_NAME
,      TABLESPACE_NAME
,      SCN
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
FROM SYS.FGR$_TABLE_INFO;

Dependencies

[top of page]

SYS.FGR$_TABLE_INFO does not reference any database object

SYS.FGR$_TABLE_INFO is referenced by following:

SchemaSYS
ViewDBA_FILE_GROUP_TABLES
Package BodyDBMS_FILE_GROUP_IMP_INTERNAL - show dependent code
Package BodyDBMS_FILE_GROUP_UTL - show dependent code
ViewUSER_FILE_GROUP_TABLES
View_ALL_FILE_GROUP_TABLES