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

TABLE: SYS.HS$_EXTERNAL_OBJECTS

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: HS$_EXTOBJ_PK
  1. ColumnEXTOBJ_ID
Unique Key: HS$_EXTOBJ_UK1
  1. ColumnFDS_INST_ID
  2. ColumnOWNER
  3. ColumnOBJECT_NAME
Indexes
Index Type Uniqueness Tablespace Column
HS$_EXTOBJ_PK NORMAL UNIQUE TablespaceSYSTEM ColumnEXTOBJ_ID
HS$_EXTOBJ_UK1 NORMAL UNIQUE TablespaceSYSTEM ColumnFDS_INST_ID
ColumnOWNER
ColumnOBJECT_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
HS$_EXTERNAL_OBJECTS HS$_EXTOBJ_FK1 TableHS$_FDS_INST HS$_EXTERNAL_OBJECTS FDS_INST_ID
TableHS$_ACCESS_GRANTEES HS$_EXTGRANT_FK1 HS$_EXTERNAL_OBJECTS HS$_ACCESS_GRANTEES EXTOBJ_ID
Columns
Name Datatype Length Mandatory Comments
EXTOBJ_ID NUMBER
Yes
FDS_INST_ID NUMBER
Yes
OWNER VARCHAR2 (30) Yes
OBJECT_NAME VARCHAR2 (30) Yes
OBJECT_TYPE VARCHAR2 (13) Yes
OBJECT_TEXT LONG (0) Yes
Query Text

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


SELECT EXTOBJ_ID
,      FDS_INST_ID
,      OWNER
,      OBJECT_NAME
,      OBJECT_TYPE
,      OBJECT_TEXT
FROM SYS.HS$_EXTERNAL_OBJECTS;

Dependencies

[top of page]

SYS.HS$_EXTERNAL_OBJECTS does not reference any database object

SYS.HS$_EXTERNAL_OBJECTS is not referenced by any database object