Home » Server Options » Text & interMedia » Coloumn is not index error in new schema
Coloumn is not index error in new schema [message #76047] Thu, 05 June 2003 01:33 Go to next message
Gokce Yarasan
Messages: 2
Registered: June 2003
Junior Member
Hi,

I create new tablespace and user and import my previously created schema in it. When I query tables
using SQL statement with contains clause like :

select count(*) as count
from content_provider
where deleted='0'
and contains(provider_name, '%%')>0
and contains(provider_code, '%%')>0

I got the following error
ORA-20000: Oracle Text error:
DRG-10599: Coloumn is not index.

This use to work pretty fine in my previous schema. Both schemas reside on same database. I also grant ctxapp right to my new user.

Any suggestions on this problem ?

Kind Regards,
Gökçe
Re: Coloumn is not index error in new schema [message #76048 is a reply to message #76047] Thu, 05 June 2003 02:27 Go to previous messageGo to next message
sinan
Messages: 5
Registered: March 2002
Junior Member
Selam

I think your new user is missing some preferences on
CTX_shema which your old user has.

try recreate your index
Re: Coloumn is not index error in new schema [message #76049 is a reply to message #76048] Thu, 05 June 2003 02:53 Go to previous message
Gokce Yarasan
Messages: 2
Registered: June 2003
Junior Member
Hi Again,

Actually the problem was index creation script created indexes on new schema without indextype as ;
indextype is ctxsys.context

Regarding this seacrh option I face another problem :
When a query a table with contains options, data that is inserted to table "after" the last rebuild of index is not returned in result data.

What can be done to solve this problem?

Cheers,
Gökçe
Previous Topic: Intermedia vs Multilingual Data
Next Topic: blob vs bfile
Goto Forum:
  


Current Time: Thu Mar 28 06:56:09 CDT 2024