VIEW: CTXSYS.CTX_USER_INDEX_PARTITIONS

Source

View Text - Preformatted

select
  ixp_id
 ,idx_name               ixp_index_name
 ,ixp_name               ixp_index_partition_name
 ,u2.name                ixp_table_owner
 ,o1.name                ixp_table_name
 ,o2.subname             ixp_table_partition_name
 ,ixp_docid_count        ixp_docid_count
 ,ixp_status             ixp_status
 ,ixp_sync_type          ixp_sync_type
 ,ixp_sync_memory        ixp_sync_memory
 ,ixp_sync_para_degree   ixp_sync_para_degree
 ,ixp_sync_interval      ixp_sync_interval
 ,ixp_sync_jobname       ixp_sync_jobname
 from dr$index_partition, dr$index, sys.user$ u2,
      sys.obj$ o1, sys.obj$ o2
where idx_owner# = userenv('SCHEMAID')
  and idx_table_owner# = u2.user#
  and ixp_table_partition# = o2.obj#
  and idx_table# = o1.obj#
  and ixp_idx_id = idx_id

View Text - HTML Formatted

SELECT IXP_ID
, IDX_NAME IXP_INDEX_NAME
, IXP_NAME IXP_INDEX_PARTITION_NAME
, U2.NAME IXP_TABLE_OWNER
, O1.NAME IXP_TABLE_NAME
, O2.SUBNAME IXP_TABLE_PARTITION_NAME
, IXP_DOCID_COUNT IXP_DOCID_COUNT
, IXP_STATUS IXP_STATUS
, IXP_SYNC_TYPE IXP_SYNC_TYPE
, IXP_SYNC_MEMORY IXP_SYNC_MEMORY
, IXP_SYNC_PARA_DEGREE IXP_SYNC_PARA_DEGREE
, IXP_SYNC_INTERVAL IXP_SYNC_INTERVAL
, IXP_SYNC_JOBNAME IXP_SYNC_JOBNAME
FROM DR$INDEX_PARTITION
, DR$INDEX
, SYS.USER$ U2
, SYS.OBJ$ O1
, SYS.OBJ$ O2 WHERE IDX_OWNER# = USERENV('SCHEMAID')
AND IDX_TABLE_OWNER# = U2.USER#
AND IXP_TABLE_PARTITION# = O2.OBJ#
AND IDX_TABLE# = O1.OBJ#
AND IXP_IDX_ID = IDX_ID