OraFAQ Forum: Text & interMedia » Text index build inso

Home » Server Options » Text & interMedia » Text index build inso_filter problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 07:52:09 CST 2025