Create Index error

From: Reny <renato.eschini_at_gmail.com>
Date: Wed, 17 Feb 2010 03:00:58 -0800 (PST)
Message-ID: <f6c6f686-0795-47bc-9476-219488521711_at_v20g2000yqv.googlegroups.com>



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. Received on Wed Feb 17 2010 - 05:00:58 CST

Original text of this message