Home » Server Options » Text & interMedia » Text index build inso_filter problem
Text index build inso_filter problem [message #76073] Thu, 23 October 2003 05:58
Dan Macklin
Messages: 1
Registered: October 2003
Junior Member

I'm using the following code to build an index on Oracle 9i release 1 on Windows 2000.

The table contains documents in many formats stored as a blob.


CREATE INDEX knowledgeIndex on knowledge(data) INDEXTYPE IS ctxsys.context parameters ('filter myinso format column fmt');

However when one of the documents times out I get the following error message :-

ORA-03113: end-of-file on communication channel

My oracle process then goes into a cpu loop and the only way I can stop it is to kill the process.

I have played with the timeout values - if I up them it just crashes later on in the index re-build.

Any help would be really appreciated.


Previous Topic: logon problem
Next Topic: why so slowly?
Goto Forum:

Current Time: Mon Aug 08 03:23:38 CDT 2022