Re: ora-3113 creating CONTEXT index on BLOB

From: joel garry <joel-garry_at_home.com>
Date: Fri, 9 Jan 2009 16:21:28 -0800 (PST)
Message-ID: <3345953c-11fb-4258-bc43-7184415663a4_at_k1g2000prb.googlegroups.com>

On Jan 9, 2: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?)

I'm sure Mark got it in one, but here's an additional curiosity you may look at. If there is something locking an object, you will eventually get a timeout leading to the catchall 3113. So you might check what is locked right after you start the create index. Perhaps Oracle is shooting itself in the foot.

(EM under the performance section looking at all locking for instance may be easiest way to see this, if monkey-like :-)

jg

--
_at_home.com is bogus.
http://news.digitaltrends.com/news-article/18730/vhs-rides-off-into-the-sunset

Received on Fri Jan 09 2009 - 18:21:28 CST