Re: Error when creating context index.

Thanks very much Ron that fixed it.

Ron Reidy wrote:

> 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:58:25 CST