| Coloumn is not index error in new schema [message #76047] |
Thu, 05 June 2003 01:33  |
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 #76049 is a reply to message #76048] |
Thu, 05 June 2003 02:53  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
