On HP Open VMS Getting ORA-3113 while Creating a Text Index on Blob Column (Doc ID 1086815.1)

Last updated on APRIL 21, 2010

Applies to:

Oracle Text - Version: 10.2.0.2 to 10.2.0.4 - Release: 10.2 to 10.2
HP OpenVMS Itanium
HP OpenVMS Alpha

Symptoms

On 10.2.0.2 HP OpenVMS Itanium platform, where AUTO_FILTER is not available, creating a Text index on BLOB column fails with ORA-3113.

SQL> CREATE INDEX I_ISBLOB_DATA2 ON ISBLOB2(DATA) INDEXTYPE IS ctxsys.context
2 parameters('lexer global_lexer language column LANG')
3 /

CREATE INDEX I_ISBLOB_DATA2
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

Indexing plain text works fine:

SQL> create table test (id number primary key, text varchar2(40));

Table created.

SQL> insert into test values(1, 'the cat sat on the mat');

1 row created.

SQL> create index testidx on test(text) indextype is ctxsys.context;

Index created.

SQL> select * from test where contains(text,'cat') > 0;


        ID TEXT
---------- ----------------------------------------
         1 the cat sat on the mat

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms