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


TABLE: SYS.HS$_INST_DD

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: HS$_INST_DD_PK
  1. ColumnFDS_INST_DD_ID
Unique Key: HS$_INST_DD_UK1
  1. ColumnFDS_INST_ID
  2. ColumnDD_TABLE_ID
Indexes
Index Type Uniqueness Tablespace Column
HS$_INST_DD_PK NORMAL UNIQUE TablespaceSYSTEM ColumnFDS_INST_DD_ID
HS$_INST_DD_UK1 NORMAL UNIQUE TablespaceSYSTEM ColumnFDS_INST_ID
ColumnDD_TABLE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
HS$_INST_DD HS$_INST_DD_FK2 TableHS$_BASE_DD HS$_INST_DD DD_TABLE_ID
HS$_INST_DD HS$_INST_DD_FK1 TableHS$_FDS_INST HS$_INST_DD FDS_INST_ID
Columns
Name Datatype Length Mandatory Comments
FDS_INST_DD_ID NUMBER
Yes
FDS_INST_ID NUMBER
Yes
DD_TABLE_ID NUMBER
Yes
TRANSLATION_TYPE CHAR (1) Yes
TRANSLATION_TEXT VARCHAR2 (4000)
Query Text

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


SELECT FDS_INST_DD_ID
,      FDS_INST_ID
,      DD_TABLE_ID
,      TRANSLATION_TYPE
,      TRANSLATION_TEXT
FROM SYS.HS$_INST_DD;

Dependencies

[top of page]

SYS.HS$_INST_DD does not reference any database object

SYS.HS$_INST_DD 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_DD
ViewHS_INST_DD