Text Index CTXCAT giving error
Hi All,
I was creating Text Index (CTXCAT) on table column using below script :
create index IDX_CUSTOMER_SEARCH1 on DIM_CUSTOMER_HIST (CUSTOMER_SEARCH)
INDEXTYPE IS CTXSYS.Ctxcat;
Its throwing below error :
Also I tried with below parameters and created preferences for that , but still giving same error:
begin
ctx_ddl.create_preference('IGCMSM2.IDX_CUSTOMER_SEARCH_LEX','BASIC_LEXER');
end;
begin
ctx_ddl.create_preference('IGCMSM2.IDX_CUSTOMER_SEARCH_WDL','BASIC_WORDLIST');
ctx_ddl.set_attribute('IGCMSM2.IDX_CUSTOMER_SEARCH_WDL','STEMMER','ENGLISH');
ctx_ddl.set_attribute('IGCMSM2.IDX_CUSTOMER_SEARCH_WDL','FUZZY_MATCH','GENERIC');
end;
begin
ctx_ddl.create_stoplist('IGCMSM2.IDX_CUSTOMER_SEARCH_SPL','BASIC_STOPLIST');