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


TABLE: HR.DR$IRC_SEARCH_CRITERIA_CTX$I

Object Details
Object Name: DR$IRC_SEARCH_CRITERIA_CTX$I
Object Type: TABLE
Owner: HR
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_IDX
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DR$IRC_SEARCH_CRITERIA_CTX$X NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDR$TOKEN
ColumnDR$TOKEN_TYPE
ColumnDR$ROWID
DR$IRC_SEARCH_CRITERIA_CTX$R NORMAL NONUNIQUE TablespaceAPPS_TS_TX_DATA ColumnDR$ROWID
Columns
Name Datatype Length Mandatory Comments
DR$TOKEN VARCHAR2 (64) Yes
DR$TOKEN_TYPE NUMBER (3) Yes
DR$ROWID ROWID (10) Yes
DR$TOKEN_INFO RAW (2000) Yes
Query Text

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


SELECT DR$TOKEN
,      DR$TOKEN_TYPE
,      DR$ROWID
,      DR$TOKEN_INFO
FROM HR.DR$IRC_SEARCH_CRITERIA_CTX$I;

Dependencies

[top of page]

HR.DR$IRC_SEARCH_CRITERIA_CTX$I does not reference any database object

HR.DR$IRC_SEARCH_CRITERIA_CTX$I is not referenced by any database object