Re: Create Index error

From: joel garry <joel-garry_at_home.com>
Date: Wed, 17 Feb 2010 13:27:58 -0800 (PST)
Message-ID: <5b921054-f566-4009-8023-89d1d5973f61_at_s36g2000prh.googlegroups.com>

On Feb 17, 3:00 am, Reny <renato.esch..._at_gmail.com> wrote:
> 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.

Shakespeare is probably right, but see MOS ID 286964.1 anyways.

jg

--
_at_home.com is bogus.
What database is your relative in?
http://www.signonsandiego.com/news/2010/feb/09/police-debate-use-of-family-dna-to-id-suspects/

Received on Wed Feb 17 2010 - 15:27:58 CST