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.

On Feb 17, 2:00*pm, Reny <renato.esch... (AT) gmail (DOT) com> wrote:
How exactly did you change the charset? This is pretty tricky process
with many caveats and what you see is most probably result of database
charset conversion done improperly.

Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com

Op 17-2-2010 14:33, Vladimir M. Zakharychev schreef:
And even more bad news: you probably can't change it back this way either.

Shakespeare

On Feb 17, 3:00*am, Reny <renato.esch... (AT) gmail (DOT) com> wrote:
Shakespeare is probably right, but see MOS ID 286964.1 anyways.

jg
--
@home.com is bogus.
What database is your relative in?
http://www.signonsandiego.com/news/2...o-id-suspects/