REPOST: 9i Intermedia Text ORA-03113 when indexing PDF documents

From: Achille Carette <acarette_nospam_at_aprico-consult.com>
Date: Thu, 24 Jan 2002 16:46:07 +0100
Message-ID: <8$--$%%%_$$$$$_--$@news.noc.cabal.int>

Oracle 9.0.1.1 / Win2000 SP2

I'm trying to create an index on a column containing PDF files, using the CREATE INDEX DOCUMENTS_TEXT_CX ON DOCUMENTS(TEXT) INDEXTYPE IS CTXSYS.CONTEXT. The TEXT column contains a PDF file. For some documents, i get the ORA-03113: end-of-file on communication channel error.

The CREATE INDEX column launches ctxhx for each row. I tried to run ctxhx alone, and it runs just fine.

I don't have any problem with other formats, as MS Word or PowerPoint.

Any idea ?

Thanks in advance,

Achille

WAS CANCELLED BY =======: From: "Achille Carette" <acarette_nospam_at_aprico-consult.com> Control: cancel <3c502c97$0$75157$ba620e4c_at_news.skynet.be> Subject: cmsg cancel <3c502c97$0$75157$ba620e4c_at_news.skynet.be> Date: Mon, 28 Jan 2002 01:58:42 GMT Message-ID: <cancel.3c502c97$0$75157$ba620e4c_at_news.skynet.be> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!nntp.cs.uni-magdeburg.de!fu-berlin.de!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40724782

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Thu Jan 24 2002 - 09:46:07 CST