Oracle Text and ORA-03113
Date: Thu, 1 Nov 2001 17:22:15 -0500
Message-ID: <9rshun$3ba$1_at_houston.jhuapl.edu>
[Quoted] [Quoted] I have a simple prototype database that I'm trying to create an index on - [Quoted] it works for small numbers of documents (5), but fails with an ORA-03113: [Quoted] end-of-file on communication channel on larger numbers of documents (more [Quoted] than around 20). I need to index more than 17,000, ultimately - some of them [Quoted] are quite large (20-30MB). The platform is a dual 500Mhz PC with 512MB of [Quoted] RAM running Win2000 Pro. The database is 9i.
The table structure:
DROP TABLE SMALL_DOCUMENT;
CREATE TABLE SMALL_DOCUMENT
(DOCUMENT_ID NUMBER,
DOCUMENT BLOB);
The create index statement:
DROP INDEX SMALL_DOCUMENT_INDEX;
CREATE INDEX SMALL_DOCUMENT_INDEX ON SMALL_DOCUMENT(DOCUMENT)
INDEXTYPE IS CTXSYS.CONTEXT;
The documents themselves are a mixture of PDF, PPT and DOC.
The same error happens whether I connect to the database using SQLWorksheet, [Quoted] or SQLPlus. I'm executing these locally at the DB server console.
The error message I get is :
Error at line 1:
ORA-03113: end-of-file on communication channel
If I try to resume the create index:
ALTER INDEX SMALL_DOCUMENT_INDEX REBUILD PARAMETERS ('resume [memory 25M]')
*
ERROR at line 1:
[Quoted] ORA-29868: cannot issue DDL on a domain index marked as LOADING
I'm stumped - any ideas? Received on Thu Nov 01 2001 - 23:22:15 CET