CTX_INDEX_PARTITIONS

This view displays all index partitions. It can be queried by CTXSYS.

Column Name	Type	Description
IXP_ID	NUMBER(38)	Index partition id.
IXP_INDEX_OWNER	VARCHAR2(30)	Index owner.
IXP_INDEX_NAME	VARCHAR2(30)	Index name.
IXP_INDEX_PARTITION_NAME	VARCHAR2(30)	Index partition name.
IXP_TABLE_OWNER	VARCHAR2(30)	Table owner.
IXP_TABLE_NAME	VARCHAR2(30)	Table name.
IXP_TABLE_PARTITION_NAME	VARCHAR2(30)	Table partition name.
IXP_DOCID_COUNT	NUMBER(38)	Number of documents associated with the partition.
IXP_STATUS	VARCHAR2(12)	Partition status.