[Home] [Help] [Dependency Information]

TABLE: CTXSYS.DR$THS_PHRASE

Object Details

Storage Details

Tablespace:	CTXD
PCT Free:	10
PCT Used:	40

Primary Key: SYS_C001034

1. THP_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
DR_UNIQ_THS_PHRASE	NORMAL	UNIQUE	CTXD	THP_THSID THP_PHRASE THP_QUALIFY
SYS_C001034	NORMAL	UNIQUE	CTXD	THP_ID
DR_THS_RINGID	NORMAL	NONUNIQUE	CTXD	THP_RINGID

Foreign Keys

Table		Foreign Table	Foreign Key Column
DR$THS_PHRASE		DR$THS	DR$THS_PHRASE THP_THSID
DR$THS_BT		DR$THS_PHRASE	DR$THS_BT THB_THP_ID
DR$THS_BT		DR$THS_PHRASE	DR$THS_BT THB_BT
DR$THS_FPHRASE		DR$THS_PHRASE	DR$THS_FPHRASE THF_THP_ID

Columns

Query Text

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

SELECT THP_ID
,      THP_THSID
,      THP_PHRASE
,      THP_QUALIFY
,      THP_NOTE
,      THP_RINGID
FROM CTXSYS.DR$THS_PHRASE;

Dependencies

[top of page]

CTXSYS.DR$THS_PHRASE does not reference any database object

CTXSYS.DR$THS_PHRASE is referenced by following:

CTXSYS

CTX_THES - show dependent code

CTX_THES_PHRASES

CTX_USER_THES_PHRASES

DRITHS - show dependent code

DRITHS - show dependent code

DRITHSC - show dependent code

DRITHSD - show dependent code

DRITHSL - show dependent code

DRITHSX - show dependent code