Create Index error

Giganews Newsgroups
Subject: Create Index error
Posted by:  Reny (renato.eschi…@gmail.com)
Date: Wed, 17 Feb 2010

Hi all,
I have this problem: I'm trieng to create a text index with this
command:

create index itemlabelvalueidx on ItemLabel (value) indextype is
ctxsys.context parameters  ('sync(ON COMMIT)');

I get this  error message:

Error starting at line 2 in command:
create index itemlabelvalueidx on ItemLabel (value) indextype is
ctxsys.context parameters  ('sync(ON COMMIT)')
Error at Command Line:2 Column:13
Error report:
SQL Error: ORA-29855: error occurred in the execution of
ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drispl.copy_stoplist
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-553: character set name is not recognized
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 365
29855. 00000 -  "error occurred in the execution of ODCIINDEXCREATE
routine"
*Cause:    Failed to successfully execute the ODCIIndexCreate routine.
*Action:  Check to see if the routine has been coded correctly.

I recently change charset from WE8ISO8859P1 to AL32UTF8, I have
restarted oracle, I have dropped all table, so I recreate schema and I
got the error.

Replies