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
Hi,

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.

begin
CTX_DDL.DROP_PREFERENCE('myinso');
ctx_ddl.create_preference('myinso','inso_filter');
ctx_ddl.set_attribute('myinso','timeout','20');
end;

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.

Thanks

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


Current Time: Sun Oct 26 04:30:40 CDT 2014

Total time taken to generate the page: 0.11641 seconds