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


TABLE: SYS.HS$_FDS_INST

Object Details
Object Name: HS$_FDS_INST
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: HS$_FDS_INST_PK
  1. ColumnFDS_INST_ID
Unique Key: HS$_FDS_INST_UK1
  1. ColumnFDS_INST_NAME
  2. ColumnFDS_CLASS_ID
Indexes
Index Type Uniqueness Tablespace Column
HS$_FDS_INST_PK NORMAL UNIQUE TablespaceSYSTEM ColumnFDS_INST_ID
HS$_FDS_INST_UK1 NORMAL UNIQUE TablespaceSYSTEM ColumnFDS_INST_NAME
ColumnFDS_CLASS_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
HS$_FDS_INST HS$_FDS_INST_FK1 TableHS$_FDS_CLASS HS$_FDS_INST FDS_CLASS_ID
TableHS$_EXTERNAL_OBJECTS HS$_EXTOBJ_FK1 HS$_FDS_INST HS$_EXTERNAL_OBJECTS FDS_INST_ID
TableHS$_GRANTED_USERS HS$_GRANTUSER_FK1 HS$_FDS_INST HS$_GRANTED_USERS FDS_INST_ID
TableHS$_INST_CAPS HS$_INST_CAPS_FK1 HS$_FDS_INST HS$_INST_CAPS FDS_INST_ID
TableHS$_INST_DD HS$_INST_DD_FK1 HS$_FDS_INST HS$_INST_DD FDS_INST_ID
TableHS$_INST_INIT HS$_INST_INIT_FK1 HS$_FDS_INST HS$_INST_INIT FDS_INST_ID
Columns
Name Datatype Length Mandatory Comments
FDS_INST_ID NUMBER
Yes
FDS_CLASS_ID NUMBER
Yes
FDS_INST_NAME VARCHAR2 (30) Yes
FDS_INST_COMMENTS VARCHAR2 (255)
Query Text

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


SELECT FDS_INST_ID
,      FDS_CLASS_ID
,      FDS_INST_NAME
,      FDS_INST_COMMENTS
FROM SYS.HS$_FDS_INST;

Dependencies

[top of page]

SYS.HS$_FDS_INST does not reference any database object

SYS.HS$_FDS_INST is referenced by following:

SchemaSYS
Package BodyDBMS_HS_ALT - show dependent code
Package BodyDBMS_HS_CHK - show dependent code
Package BodyDBMS_HS_UTL - show dependent code
ViewHS_ALL_CAPS
ViewHS_ALL_DD
ViewHS_ALL_INITS
ViewHS_FDS_INST
ViewHS_INST_CAPS
ViewHS_INST_DD
ViewHS_INST_INIT