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


TABLE: SYS.HS$_BASE_DD

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: HS$_BASE_DD_PK
  1. ColumnDD_TABLE_ID
Unique Key: HS$_BASE_DD_UK1
  1. ColumnDD_TABLE_NAME
Indexes
Index Type Uniqueness Tablespace Column
HS$_BASE_DD_PK NORMAL UNIQUE TablespaceSYSTEM ColumnDD_TABLE_ID
HS$_BASE_DD_UK1 NORMAL UNIQUE TablespaceSYSTEM ColumnDD_TABLE_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
TableHS$_CLASS_DD HS$_CLASS_DD_FK2 HS$_BASE_DD HS$_CLASS_DD DD_TABLE_ID
TableHS$_INST_DD HS$_INST_DD_FK2 HS$_BASE_DD HS$_INST_DD DD_TABLE_ID
Columns
Name Datatype Length Mandatory Comments
DD_TABLE_ID NUMBER
Yes
DD_TABLE_NAME VARCHAR2 (128) Yes
DD_TABLE_DESC VARCHAR2 (255)
Query Text

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


SELECT DD_TABLE_ID
,      DD_TABLE_NAME
,      DD_TABLE_DESC
FROM SYS.HS$_BASE_DD;

Dependencies

[top of page]

SYS.HS$_BASE_DD does not reference any database object

SYS.HS$_BASE_DD is referenced by following:

SchemaSYS
Package BodyDBMS_HS - show dependent code
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_BASE_DD
ViewHS_CLASS_DD
ViewHS_INST_DD