=========================================================================== INDEX DESCRIPTION =========================================================================== index name: "APPS"."XXCSS_QOT_LINE_CTX_INDX" index id: 4026 index type: context base table: "APPS"."XXCSS_QOT_LINES_SEARCH_BK" primary key column: text column: DUMMY text column type: VARCHAR2(4000) language column: format column: charset column: index option: transactional-query status: POPULATE full optimize token: full optimize count: docid count: 106174308 nextid: 106462966 =========================================================================== INDEX OBJECTS =========================================================================== datastore: USER_DATASTORE procedure: APPS.XXCSS_QOT_SEARCH_MDATA_B.LINES_SEARCH_INDX_PROC filter: NULL_FILTER section group: HTML_SECTION_GROUP mdata section: QUOTEHEADERID section tag: QUOTEHEADERID visible: N field id: 401 mdata section: PRODUCTNAME section tag: PRODUCTNAME visible: N field id: 402 mdata section: INSTALLSITE section tag: INSTALLSITE visible: N field id: 403 mdata section: SERVICELEVEL section tag: SERVICELEVEL visible: N field id: 404 mdata section: SERIALNUMBER section tag: SERIALNUMBER visible: N field id: 405 mdata section: SCONTRACTNUM section tag: SCONTRACTNUM visible: N field id: 406 mdata section: TCONTRACTNUM section tag: TCONTRACTNUM visible: N field id: 407 mdata section: PROJECTNUMBER section tag: PROJECTNUMBER visible: N field id: 408 mdata section: ASPTQOTNUMBER section tag: ASPTQOTNUMBER visible: N field id: 409 mdata section: QUOTELINEID section tag: QUOTELINEID visible: N field id: 400 lexer: BASIC_LEXER index_themes: NO wordlist: BASIC_WORDLIST stemmer: ENGLISH fuzzy_match: GENERIC stoplist: BASIC_STOPLIST storage: BASIC_STORAGE i_table_clause: tablespace xxcssd1 storage (initial 1024M next 20M) nologging k_table_clause: tablespace xxcssd1 nologging r_table_clause: tablespace xxcssd1 lob(data)store as (disable storage in row nocache nologging) nologging n_table_clause: tablespace xxcssd1 nologging i_index_clause: tablespace xxcssd1 storage (initial 256M next 20M)compress 2 nologging