Home » Server Options » Text & interMedia » ctxcat indexing problems
ctxcat indexing problems [message #76104] Mon, 19 July 2004 00:23 Go to next message
Axel D
Messages: 3
Registered: July 2004
Junior Member
Hello!

I have set up a table (oracle 9) with three ctxcat indexed rows.
- town (varchar2 50)
- country (varchar2 50)
- description (varchar2 4000)
The table is filled with ~50.000 rows.
"town" and "country" are updating without any problem, but not "description". The indexsize is about 50MB. Maybe this size doesn't work without manual intervention?? Does anybody know how to deal this?

Best regards, Axel
Re: ctxcat indexing problems [message #76147 is a reply to message #76104] Sun, 28 November 2004 09:10 Go to previous messageGo to next message
Just John
Messages: 69
Registered: November 2004
Member
the CTX indexes work on CLOBs so an VARCHAR2(4000) should be childs-play.

not much help I agree but it should work(?)

could you change the datatype to a clob to see if it is the (4000) size that is causing the issue?
Re: ctxcat indexing problems [message #119856 is a reply to message #76104] Mon, 16 May 2005 07:33 Go to previous messageGo to next message
vasso
Messages: 5
Registered: May 2005
Junior Member
The right SQL Statement is:

UPDATE RETRIEVABLE_TEXTS
SET
town = :town,
country = :country,
description = empty_Blob(),
WHERE
(PrimaryKey) = :OLD_(PrimaryKey)
RETURNING
discription
INTO
:value_description;

You use this?
If you don't, you will have problems?

[Updated on: Mon, 16 May 2005 07:34]

Report message to a moderator

Re: ctxcat indexing problems [message #121087 is a reply to message #76104] Thu, 26 May 2005 00:05 Go to previous message
rhardman
Messages: 25
Registered: April 2005
Junior Member
I can't help but think that vasso meant that post for another forum entry.

Please post the error you are getting on index creation here. Also post the index creation script you are using (including any sub-indexes). Unless you are running into a bug, the column definition is not the problem.

-Ron
Previous Topic: Can Ultra Search be used to only validate links?
Next Topic: file_datastore(indexing pdfs)
Goto Forum:
  


Current Time: Thu Mar 28 11:50:43 CDT 2024