Home » Server Options » Text & interMedia » Index Creation (Oracle 10g / AIX)
Index Creation [message #388432] Tue, 24 February 2009 13:08 Go to next message
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
Member
Hi

While trying to create a index I am getting the below error

ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10582: column SEARCH_LANG does not exist in table CITI_CMLINK_ATTR
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364


I checked the index name in DBA_INDEXES, its created and is in valid state. But while loading the data to this table getting error as

DBD: Exception Message: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

What would be issue?
Re: Index Creation [message #388433 is a reply to message #388432] Tue, 24 February 2009 13:14 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

>What would be issue?
DRG-10582: column SEARCH_LANG does not exist in table CITI_CMLINK_ATTR
Re: Index Creation [message #389341 is a reply to message #388433] Sat, 28 February 2009 21:51 Go to previous message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
The error message is pretty self-explanatory. The code that was issued to create the index requires a column named search_lang in the CITI_CMLINK_ATTR table, but there isn't one. You are probably attempting to create an index that uses a multi_lexer or some such preference on a multi-language table and you have specified the search_lang column during the index creation, but have not included that column in the table. Please see the example below that first reproduces the error, then corrects it by adding the search_lang column and dropping and recreating the index.

SCOTT@orcl_11g> CREATE TABLE CITI_CMLINK_ATTR
  2    (some_column  VARCHAR2 (30))
  3  /

Table created.

SCOTT@orcl_11g> begin
  2    ctx_ddl.create_preference('english_lexer','basic_lexer');
  3    ctx_ddl.set_attribute('english_lexer','index_themes','yes');
  4    ctx_ddl.set_attribute('english_lexer','theme_language','english');
  5    ctx_ddl.create_preference('german_lexer','basic_lexer');
  6    ctx_ddl.set_attribute('german_lexer','composite','german');
  7    ctx_ddl.set_attribute('german_lexer','mixed_case','yes');
  8    ctx_ddl.set_attribute('german_lexer','alternate_spelling','german');
  9    ctx_ddl.create_preference('japanese_lexer','japanese_vgram_lexer');
 10    ctx_ddl.create_preference('global_lexer', 'multi_lexer');
 11    ctx_ddl.add_sub_lexer('global_lexer','default','english_lexer');
 12    ctx_ddl.add_sub_lexer('global_lexer','german','german_lexer','ger');
 13    ctx_ddl.add_sub_lexer('global_lexer','japanese','japanese_lexer','jpn');
 14  end;
 15  /

PL/SQL procedure successfully completed.

SCOTT@orcl_11g> CREATE INDEX your_index
  2  ON CITI_CMLINK_ATTR (some_column)
  3  INDEXTYPE IS CTXSYS.CONTEXT
  4  parameters ('lexer global_lexer language column search_lang')
  5  /
CREATE INDEX your_index
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10582: column SEARCH_LANG does not exist in table CITI_CMLINK_ATTR
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 365


SCOTT@orcl_11g> SELECT status
  2  FROM   dba_indexes
  3  WHERE  index_name = 'YOUR_INDEX'
  4  /

STATUS
--------
VALID

SCOTT@orcl_11g> ALTER TABLE CITI_CMLINK_ATTR ADD (search_lang  VARCHAR2 (3))
  2  /

Table altered.

SCOTT@orcl_11g> DROP INDEX your_index
  2  /

Index dropped.

SCOTT@orcl_11g> CREATE INDEX your_index
  2  ON CITI_CMLINK_ATTR (some_column)
  3  INDEXTYPE IS CTXSYS.CONTEXT
  4  parameters ('lexer global_lexer language column search_lang')
  5  /

Index created.

SCOTT@orcl_11g>

Previous Topic: CONTEXT SCORE is equal...
Next Topic: Recreating Fuzzy index for each insert
Goto Forum:
  


Current Time: Thu Mar 28 04:41:29 CDT 2024