Re: Error when creating context index.

 From metalink:

• fact: InterMedia Text 9.2
• symptom: Creation of a Text index fails
• symptom: DRG-10502: index %(1)s does not exist
• symptom: ORA-00600: internal error code, arguments: [OPIBND1],[],[],[],[],[] ,[],[] * cause: This error occurs when the parameter cursor_sharing is set to 'similar' or 'force'. <BUG:2474192>: 'ORA-600:[OPIBND1] BY TEXT INDEX WHEN CURSOR_SHARING=SIMILAR'. This bug is solved in 10i.

fix:

Set the parameter cursor_sharing to exact either in the init.ora or by means of
the alter session command.

technical_at_fastwebmedia.co.uk wrote:
> Hello,
>
> Every time I try and create a context index using the following command
> or similar:
>
> create index I_CTX_NEWS_TITLE on NEWS (TITLE) indextype is
> ctxsys.context parameters ('storage megsoc_storage');
>
> I get the following errors:
>
> ERROR at line 1:
> ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
> ORA-20000: Oracle Text error:
> DRG-10502: index I_CTX_NEWS_TITLE does not exist
> DRG-50857: oracle error in drdmlpo
> ORA-00600: internal error code, arguments: [opibnd1], [], [], [], [],
> [], [],
> []
> ORA-06512: at "CTXSYS.DRUE", line 157
> ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 186
>
> Does anyone have any idea what might be causing this?
>
> I'm using Oracle 9i release 2 on redhat linux.
>
> Thanks,
>
> Simon.
>
Received on Wed Jan 15 2003 - 05:06:17 CST