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


TABLE: SYS.HS$_FDS_CLASS

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: HS$_FDS_CLASS_PK
  1. ColumnFDS_CLASS_ID
Unique Key: HS$_FDS_CLASS_UK1
  1. ColumnFDS_CLASS_NAME
Indexes
Index Type Uniqueness Tablespace Column
HS$_FDS_CLASS_PK NORMAL UNIQUE TablespaceSYSTEM ColumnFDS_CLASS_ID
HS$_FDS_CLASS_UK1 NORMAL UNIQUE TablespaceSYSTEM ColumnFDS_CLASS_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
TableHS$_CLASS_CAPS HS$_CLASS_CAPS_FK1 HS$_FDS_CLASS HS$_CLASS_CAPS FDS_CLASS_ID
TableHS$_CLASS_DD HS$_CLASS_DD_FK1 HS$_FDS_CLASS HS$_CLASS_DD FDS_CLASS_ID
TableHS$_CLASS_INIT HS$_CLASS_INIT_FK1 HS$_FDS_CLASS HS$_CLASS_INIT FDS_CLASS_ID
TableHS$_FDS_INST HS$_FDS_INST_FK1 HS$_FDS_CLASS HS$_FDS_INST FDS_CLASS_ID
Columns
Name Datatype Length Mandatory Comments
FDS_CLASS_ID NUMBER
Yes
FDS_CLASS_NAME VARCHAR2 (30) Yes
FDS_CLASS_COMMENTS VARCHAR2 (255)
Query Text

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


SELECT FDS_CLASS_ID
,      FDS_CLASS_NAME
,      FDS_CLASS_COMMENTS
FROM SYS.HS$_FDS_CLASS;

Dependencies

[top of page]

SYS.HS$_FDS_CLASS does not reference any database object

SYS.HS$_FDS_CLASS 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_CLASS_CAPS
ViewHS_CLASS_DD
ViewHS_CLASS_INIT
ViewHS_FDS_CLASS
ViewHS_FDS_CLASS_DATE
ViewHS_FDS_INST
ViewHS_INST_CAPS
ViewHS_INST_DD
ViewHS_INST_INIT