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


TABLE: SYS.WI$_OBJECT

Object Details
Object Name: WI$_OBJECT
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: WI$_OBJECT_PK
  1. ColumnJOBID
  2. ColumnTEMPLATEID
  3. ColumnOBJECTID
Indexes
Index Type Uniqueness Tablespace Column
WI$_OBJECT_PK NORMAL UNIQUE TablespaceSYSAUX ColumnJOBID
ColumnTEMPLATEID
ColumnOBJECTID
Foreign Keys
Table
Foreign Table Foreign Key Column
WI$_OBJECT WI$_OBJECT_FK1 TableWI$_TEMPLATE WI$_OBJECT JOBID
WI$_OBJECT TEMPLATEID
Columns
Name Datatype Length Mandatory Comments
JOBID NUMBER
Yes
TEMPLATEID NUMBER
Yes
OBJECTID NUMBER
Yes
ACCESSTYPE VARCHAR2 (2) Yes
Query Text

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


SELECT JOBID
,      TEMPLATEID
,      OBJECTID
,      ACCESSTYPE
FROM SYS.WI$_OBJECT;

Dependencies

[top of page]

SYS.WI$_OBJECT does not reference any database object

SYS.WI$_OBJECT is referenced by following:

SchemaSYS
ViewDBA_WI_OBJECTS