Re: Oracle Text and ORA-03113

Bruce Miller wrote:
>
> I have a simple prototype database that I'm trying to create an index on -
> it works for small numbers of documents (5), but fails with an ORA-03113:
> end-of-file on communication channel on larger numbers of documents (more
> than around 20). I need to index more than 17,000, ultimately - some of them
> are quite large (20-30MB). The platform is a dual 500Mhz PC with 512MB of
> 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,
> 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:
> ORA-29868: cannot issue DDL on a domain index marked as LOADING
>
> I'm stumped - any ideas?
Look in the instance's alert log. the real error will be there.

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.