| ctxcat indexing problems [message #76104] |
Mon, 19 July 2004 00:23  |
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  |
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 |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
