ora-3113 creating CONTEXT index on BLOB

From: Malcolm Dunnett <nothome_at_spammers.are.scum>
Date: Fri, 09 Jan 2009 14:15:53 -0800
Message-ID: <4967cc97$1_at_flight>

Oracle Standard Edition 10.2.0.2 on OpenVMS 8.3 (Itanium server)

I am attempting to create a CTXSYS.CONTEXT index on a blob column in a table. When I run the command I get:

SQL> CREATE INDEX XXX ON FRS_DOCUMENT_STORE(DOCUMENT_DATA) INDEXTYPE IS CTXSYS.CONTEXT;
             *
ERROR at line 1:
ORA-03113: end-of-file on communication channel

(so clearly the server process is heading south)

The table definition is:

CREATE TABLE frs_document_store

     (document_id                    NUMBER(10,0) NOT NULL,
     document_data                  BLOB

   ,
   CONSTRAINT FRS_DOCUMENT_STORE_PK
   PRIMARY KEY (document_id)
   USING INDEX
   PCTFREE 10
   INITRANS 2
   MAXTRANS 255
   STORAGE (

     INITIAL     65536
     MINEXTENTS  1
     MAXEXTENTS  2147483645


   ))

   PCTFREE     10

   INITRANS 1
   MAXTRANS 255
   STORAGE (

     INITIAL     65536
     MINEXTENTS  1
     MAXEXTENTS  2147483645

)

   LOB (DOCUMENT_DATA) STORE AS SYS_LOB0000141710C00002$$    (
   STORAGE (

     INITIAL     65536
     MINEXTENTS  1
     MAXEXTENTS  2147483645

)

    NOCACHE LOGGING
    CHUNK 8192
)

/

There are no errors in the alert log and no trace file gets created.

If I execute the same command against a varchar2 column it succeeds.

Any idea what is wrong (or even why I don't get a trace file?) Received on Fri Jan 09 2009 - 16:15:53 CST