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

TABLE: CTXSYS.DR$THS_FPHRASE

Object Details
Object Name: DR$THS_FPHRASE
Object Type: TABLE
Owner: CTXSYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: Tablespace
PCT Free: 0
PCT Used: 0
Primary Key: SYS_IOT_TOP_21638
  1. ColumnTHF_THP_ID
  2. ColumnTHF_PHRASE
  3. ColumnTHF_TYPE
Indexes
Index Type Uniqueness Tablespace Column
SYS_IOT_TOP_21638 IOT - TOP UNIQUE TablespaceCTXD ColumnTHF_THP_ID
ColumnTHF_PHRASE
ColumnTHF_TYPE
Foreign Keys
Table
Foreign Table Foreign Key Column
DR$THS_FPHRASE SYS_C001039 TableDR$THS_PHRASE DR$THS_FPHRASE THF_THP_ID
Columns
Name Datatype Length Mandatory Comments
THF_THP_ID NUMBER
Yes
THF_PHRASE VARCHAR2 (256) Yes
THF_TYPE VARCHAR2 (10) Yes
Query Text

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


SELECT THF_THP_ID
,      THF_PHRASE
,      THF_TYPE
FROM CTXSYS.DR$THS_FPHRASE;

Dependencies

[top of page]

CTXSYS.DR$THS_FPHRASE does not reference any database object

CTXSYS.DR$THS_FPHRASE is referenced by following:

SchemaCTXSYS
Package BodyCTX_THES - show dependent code
Package BodyDRITHSC - show dependent code
Package BodyDRITHSD - show dependent code
Package BodyDRITHSL - show dependent code
Package BodyDRITHSX - show dependent code