Create ctxsys.context indexes Oracle 9.2


I was trying to create text index on long type field. Simple task, did that a lot in 8i without problem.
In 9i immediately after  executing CREATE INDEX SCRIPT_TEXTINDEX ON PropertyScript(script)  INDEXTYPE IS ctxsys.context
I got
ERROR at line 1:
ORA-03113: end-of-file on communication channel
which basically means that it just throw me out. But after I logged in again I noticed that the Index was created with the status 'Loading' and it just hangs there loading... and I can't drop it or do anything else.

Any insights? Thanks in advance!!!
Who is Participating?

You can get rid of it with

drop index <indexname> force;
some info on this from metalink, for what its worth.

-- It would be advisable to use CLOBs as LONG and LONG RAWs are going to be desupported in future releases.

-- Located Bug:2532065 <CREATE CONTEXT INDEX ON A LONG COLUMN RESULTS ORA-3113 CORE DUMP ON SERVER>, Pub:Y, which development could not reproduce on

-- Since there are many Oracle text bugs with LONG datatypes, it would be advisable if its not possible to convert to LOBs, to apply the latest patchset(

and a potential solution:

Doc ID:  Note:2257361.8
Subject:  Support Description of Bug 2257361
Type:  PATCH
 Content Type:  TEXT/X-HTML
Creation Date:  13-AUG-2003
Last Revision Date:  17-NOV-2003
 Click here for details of sections in this note.

Bug 2257361  ORA-3113/ORA-600 indexing an multi-byte data in XML CDATA sections
 This note gives a brief overview of bug 2257361.

Product (Component) Oracle Text (Generic/Default)
Range of versions believed to be affected Versions >= 8 but < 10G  
Versions confirmed as being affected
Platforms affected Generic (all / most platforms affected)

This issue is fixed in iAS Patch Set (Server Patch Set)
10g Production Base Release

Memory Corruption
Process may Dump / Abend / Abort
Error may occur
Internal Error may occur (ORA-600)
Related To:
Oracle Text (formerly interMedia Text)

Indexing a document containing multi-byte characters held in XML
CDATA sections can fail with ORA-3113, ORA-3114, ORA-7445 or
ORA-600.  This only happens for some documents depending on the
location and length of the CDATA data.


RimmaCAuthor Commented:
thanks a lot for helped, I figured 'force' drop but it was an answer.
Especial thanks for all that helpful info from oratim
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.