[Home] [Help] [Dependency Information]

TABLE: CTXSYS.DR$INDEX_PARTITION

Object Details

Storage Details

Tablespace:	CTXD
PCT Free:	10
PCT Used:	40

Primary Key: DRC$IXP_KEY

1. IXP_IDX_ID
2. IXP_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
DRC$IXP_KEY	NORMAL	UNIQUE	CTXD	IXP_IDX_ID IXP_ID
DRX$IXP_NAME	NORMAL	UNIQUE	CTXD	IXP_IDX_ID IXP_NAME

Columns

Query Text

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

SELECT IXP_ID
,      IXP_NAME
,      IXP_IDX_ID
,      IXP_TABLE_PARTITION#
,      IXP_DOCID_COUNT
,      IXP_STATUS
,      IXP_NEXTID
,      IXP_OPT_TOKEN
,      IXP_OPT_TYPE
,      IXP_OPT_COUNT
,      IXP_SYNC_TYPE
,      IXP_SYNC_MEMORY
,      IXP_SYNC_PARA_DEGREE
,      IXP_SYNC_INTERVAL
,      IXP_SYNC_JOBNAME
,      IXP_OPTION
FROM CTXSYS.DR$INDEX_PARTITION;

Dependencies

[top of page]

CTXSYS.DR$INDEX_PARTITION does not reference any database object

CTXSYS.DR$INDEX_PARTITION is referenced by following:

APPS

HZ_DQM_SYNC - show dependent code

CTXSYS

CTX_FILTER_CACHE_STATISTICS

CTX_INDEX_PARTITIONS

CTX_PENDING

CTX_USER_INDEX_PARTITIONS

CTX_USER_PENDING

DRIDML - show dependent code

DRIEXP - show dependent code

DRIIMP - show dependent code

DRIOPT - show dependent code

DRIRIO - show dependent code

DRIUTL - show dependent code

DRIXMD - show dependent code

DRVLSB - show dependent code