VIEW: CTXSYS.CTX_INDEXES

Source

View Text - Preformatted

select
  idx_id
 ,u.name                 idx_owner
 ,idx_name               idx_name
 ,u2.name                idx_table_owner
 ,o.name                 idx_table
 ,idx_key_name           idx_key_name
 ,idx_text_name          idx_text_name
 ,idx_docid_count        idx_docid_count
 ,idx_status             idx_status
 ,idx_language_column    idx_language_column
 ,idx_format_column      idx_format_column
 ,idx_charset_column     idx_charset_column
 ,decode(idx_type, 0, 'CONTEXT', 1, 'CTXCAT', 2, 'CTXRULE') idx_type
 ,idx_sync_type          idx_sync_type
 ,idx_sync_memory        idx_sync_memory
 ,idx_sync_para_degree   idx_sync_para_degree
 ,idx_sync_interval      idx_sync_interval
 ,idx_sync_jobname       idx_sync_jobname
 ,decode(instr(idx_option, 'Z'), 0, 'NO', NULL, 'NO', 'YES')
                         idx_query_stats_enabled
 from dr$index, sys.user$ u, sys.obj$ o, sys.user$ u2
where idx_owner# = u.user#
  and idx_table_owner# = u2.user#
  and idx_table# = o.obj#

View Text - HTML Formatted

SELECT IDX_ID
, U.NAME IDX_OWNER
, IDX_NAME IDX_NAME
, U2.NAME IDX_TABLE_OWNER
, O.NAME IDX_TABLE
, IDX_KEY_NAME IDX_KEY_NAME
, IDX_TEXT_NAME IDX_TEXT_NAME
, IDX_DOCID_COUNT IDX_DOCID_COUNT
, IDX_STATUS IDX_STATUS
, IDX_LANGUAGE_COLUMN IDX_LANGUAGE_COLUMN
, IDX_FORMAT_COLUMN IDX_FORMAT_COLUMN
, IDX_CHARSET_COLUMN IDX_CHARSET_COLUMN
, DECODE(IDX_TYPE
, 0
, 'CONTEXT'
, 1
, 'CTXCAT'
, 2
, 'CTXRULE') IDX_TYPE
, IDX_SYNC_TYPE IDX_SYNC_TYPE
, IDX_SYNC_MEMORY IDX_SYNC_MEMORY
, IDX_SYNC_PARA_DEGREE IDX_SYNC_PARA_DEGREE
, IDX_SYNC_INTERVAL IDX_SYNC_INTERVAL
, IDX_SYNC_JOBNAME IDX_SYNC_JOBNAME
, DECODE(INSTR(IDX_OPTION
, 'Z')
, 0
, 'NO'
, NULL
, 'NO'
, 'YES') IDX_QUERY_STATS_ENABLED
FROM DR$INDEX
, SYS.USER$ U
, SYS.OBJ$ O
, SYS.USER$ U2 WHERE IDX_OWNER# = U.USER#
AND IDX_TABLE_OWNER# = U2.USER#
AND IDX_TABLE# = O.OBJ#