[Home] [Help] [Dependency Information]
Object Name: | CTX_USER_INDEXES |
---|---|
Object Type: | VIEW |
Owner: | CTXSYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
IDX_ID | NUMBER | (38) | Yes | |
IDX_NAME | VARCHAR2 | (30) | Yes | |
IDX_TABLE_OWNER | VARCHAR2 | (128) | Yes | |
IDX_TABLE | VARCHAR2 | (128) | Yes | |
IDX_KEY_NAME | VARCHAR2 | (256) | ||
IDX_TEXT_NAME | VARCHAR2 | (256) | Yes | |
IDX_DOCID_COUNT | NUMBER | |||
IDX_STATUS | VARCHAR2 | (12) | Yes | |
IDX_LANGUAGE_COLUMN | VARCHAR2 | (256) | ||
IDX_FORMAT_COLUMN | VARCHAR2 | (256) | ||
IDX_CHARSET_COLUMN | VARCHAR2 | (256) | ||
IDX_TYPE | VARCHAR2 | (7) | ||
IDX_SYNC_TYPE | VARCHAR2 | (20) | ||
IDX_SYNC_MEMORY | VARCHAR2 | (100) | ||
IDX_SYNC_PARA_DEGREE | NUMBER | |||
IDX_SYNC_INTERVAL | VARCHAR2 | (2000) | ||
IDX_SYNC_JOBNAME | VARCHAR2 | (50) | ||
IDX_QUERY_STATS_ENABLED | VARCHAR2 | (3) |
Cut, paste (and edit) the following text to query this object:
SELECT IDX_ID
, IDX_NAME
, IDX_TABLE_OWNER
, IDX_TABLE
, IDX_KEY_NAME
, IDX_TEXT_NAME
, IDX_DOCID_COUNT
, IDX_STATUS
, IDX_LANGUAGE_COLUMN
, IDX_FORMAT_COLUMN
, IDX_CHARSET_COLUMN
, IDX_TYPE
, IDX_SYNC_TYPE
, IDX_SYNC_MEMORY
, IDX_SYNC_PARA_DEGREE
, IDX_SYNC_INTERVAL
, IDX_SYNC_JOBNAME
, IDX_QUERY_STATS_ENABLED
FROM CTXSYS.CTX_USER_INDEXES;
|
|
|