Re: ora-3113 creating CONTEXT index on BLOB

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Fri, 9 Jan 2009 16:03:50 -0800 (PST)
Message-ID: <cc8fbce4-50fe-4848-84d8-64fe72be269f_at_r37g2000prr.googlegroups.com>

On Jan 9, 5:15 pm, Malcolm Dunnett <noth..._at_spammers.are.scum> wrote:
> 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?)

Any error messages in the Alert.log or is a core dump produced?

I found three hits on a search for ORA-03113 and CTSSYS.CONTEXT on the Oracle support web site (formerly metalink) "Index With URL_DATASTORE Fails With Core Dump" #754924.1 is recently entered (Dec 2008) and matches your version of Oracle so I definitely think this one is worth a read

Did you verify your ctx_ddl.create_preference and ctx_ddl.set_attribute for the index you are trying to create?

HTH -- Mark D Powell -- Received on Fri Jan 09 2009 - 18:03:50 CST