Skip to content

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

TABLE: SYS.XS$INSTSET_LIST

Object Details
Object Name: XS$INSTSET_LIST
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: XS$DSEC_INSTSET_UK
  1. ColumnXDSID#
  2. ColumnORDER#
Indexes
Index Type Uniqueness Tablespace Column
XS$DSEC_INSTSET_UK NORMAL UNIQUE TablespaceSYSTEM ColumnXDSID#
ColumnORDER#
Foreign Keys
Table
Foreign Table Foreign Key Column
XS$INSTSET_LIST XS$DSEC_INSTSET_FK TableXS$DSEC XS$INSTSET_LIST XDSID#
TableXS$INSTSET_INH XS$INSTSET_INH_FK XS$INSTSET_LIST XS$INSTSET_INH XDSID#
XS$INSTSET_INH ORDER#
TableXS$INSTSET_RULE XS$INSTSET_RULE_FK XS$INSTSET_LIST XS$INSTSET_RULE XDSID#
XS$INSTSET_RULE ORDER#
Columns
Name Datatype Length Mandatory Comments
XDSID# NUMBER
Yes
ORDER# NUMBER
Yes
TYPE NUMBER

Query Text

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


SELECT XDSID#
,      ORDER#
,      TYPE
FROM SYS.XS$INSTSET_LIST;

Dependencies

[top of page]

SYS.XS$INSTSET_LIST does not reference any database object

SYS.XS$INSTSET_LIST is referenced by following:

SchemaSYS
ViewDBA_XS_REALM_CONSTRAINTS
ViewKU$_XSINSTSET_VIEW
Package BodyXS_DATA_SECURITY_INT - show dependent code
Package BodyXS_DIAG_INT - show dependent code