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

TABLE: SYS.CHNF$_GROUP_FILTER_IOT

Object Details
Object Name: CHNF$_GROUP_FILTER_IOT
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: Tablespace
PCT Free: 0
PCT Used: 0
Primary Key: SYS_IOT_TOP_469145
  1. ColumnOBJECTNUM
  2. ColumnCOLID
  3. ColumnOPERATOR
  4. ColumnRHSVAL
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000469145C00003$$ LOB UNIQUE TablespaceSYSAUX
SYS_IOT_TOP_469145 IOT - TOP UNIQUE TablespaceSYSAUX ColumnOBJECTNUM
ColumnCOLID
ColumnOPERATOR
ColumnRHSVAL
Columns
Name Datatype Length Mandatory Comments
OBJECTNUM NUMBER
Yes
EXPRFILTER CHAR (1)
EXPRLHS CLOB (4000)
COLID NUMBER
Yes
OPERATOR NUMBER
Yes
RHSVAL RAW (500) Yes
FILTERID NUMBER

Query Text

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


SELECT OBJECTNUM
,      EXPRFILTER
,      EXPRLHS
,      COLID
,      OPERATOR
,      RHSVAL
,      FILTERID
FROM SYS.CHNF$_GROUP_FILTER_IOT;

Dependencies

[top of page]

SYS.CHNF$_GROUP_FILTER_IOT does not reference any database object

SYS.CHNF$_GROUP_FILTER_IOT is not referenced by any database object