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


TABLE: CTXSYS.DR$THS_BT

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

Storage Details
Tablespace: TablespaceCTXD
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
DR_UNIQ_THS_BT NORMAL UNIQUE TablespaceCTXD ColumnTHB_THP_ID
ColumnTHB_TYPE
ColumnTHB_BT
DR_THS_BT NORMAL NONUNIQUE TablespaceCTXD ColumnTHB_BT
ColumnTHB_TYPE
Foreign Keys
Table
Foreign Table Foreign Key Column
DR$THS_BT SYS_C001042 TableDR$THS_PHRASE DR$THS_BT THB_BT
DR$THS_BT SYS_C001041 TableDR$THS_PHRASE DR$THS_BT THB_THP_ID
Columns
Name Datatype Length Mandatory Comments
THB_THP_ID NUMBER

THB_TYPE VARCHAR2 (3) Yes
THB_BT NUMBER

Query Text

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


SELECT THB_THP_ID
,      THB_TYPE
,      THB_BT
FROM CTXSYS.DR$THS_BT;

Dependencies

[top of page]

CTXSYS.DR$THS_BT does not reference any database object

CTXSYS.DR$THS_BT 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