Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Create ctxsys.context indexes Oracle 9.2

Posted on 2004-10-29
Medium Priority
Last Modified: 2008-01-09

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!!!
Question by:RimmaC
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

BobMc earned 200 total points
ID: 12447679

You can get rid of it with

drop index <indexname> force;

Assisted Solution

oratim earned 200 total points
ID: 12447767
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.



Author Comment

ID: 12447960
thanks a lot for helped, I figured 'force' drop but it was an answer.
Especial thanks for all that helpful info from oratim

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question