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


TABLE: SYS.HS$_BASE_CAPS

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: HS$_BASE_CAPS_PK
  1. ColumnCAP_NUMBER
Indexes
Index Type Uniqueness Tablespace Column
HS$_BASE_CAPS_PK NORMAL UNIQUE TablespaceSYSTEM ColumnCAP_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
TableHS$_CLASS_CAPS HS$_CLASS_CAPS_FK2 HS$_BASE_CAPS HS$_CLASS_CAPS CAP_NUMBER
TableHS$_INST_CAPS HS$_INST_CAPS_FK2 HS$_BASE_CAPS HS$_INST_CAPS CAP_NUMBER
Columns
Name Datatype Length Mandatory Comments
CAP_NUMBER NUMBER
Yes
CAP_DESCRIPTION VARCHAR2 (255)
Query Text

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


SELECT CAP_NUMBER
,      CAP_DESCRIPTION
FROM SYS.HS$_BASE_CAPS;

Dependencies

[top of page]

SYS.HS$_BASE_CAPS does not reference any database object

SYS.HS$_BASE_CAPS 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_CAPS
ViewHS_BASE_CAPS
ViewHS_CLASS_CAPS
ViewHS_INST_CAPS