Re: Oracle Intermedia Text problem

clob : try to not use such datatypes .... why do you use clob ?

intermedia: you need to rebuild regulary your context index, you can do it online, see your doc about it.

Erik.
Oracle DBA consultant

ikipnis_at_ucg.com (Inna Kipnis) wrote in message news:<f7fe21b.0111021032.62b9b82c_at_posting.google.com>...
> May be somebody can help me with a problem using Intermedia Text
> search.
> The following query returns different results depending on the amount
> of data in the searched column or the use of wildcards:
>
> SELECT DISTINCT SolNbr
> FROM Notice_Data
> WHERE NOTICE_TYPE_ID IN ( 1,2,3,4,7,8, 0 ) AND
> (CONTAINS(SUBJ_DESC,'(audio produc%) OR (audio project%) OR (audio
> video) OR (audio visual service%) OR (broadcast production) OR
> (editing system%) OR (interactive multimedia ) OR (motion picture) OR
> (motion video) OR (multi% media) OR (multimedia material%) OR
> (multimedia presentation) OR (multimedia service%) OR (multimedia
> system%) OR (museum%) OR (near((produc, video%),4)) OR (near((produc,
> televis%),4)) OR (near((produc, edit%),2)) OR (program edit%) OR
> (near((program, televis%),3)) OR (near((program, video%),3)) OR
> (program% education%) OR (near((proposal, video),2)) OR (public
> service announcement ) OR (publication video) OR (real% time video) OR
> (special effect%) OR (near((taping, video%),2)) OR (near((televis,
> program%),3)) OR (television broadcast%) OR (television production) OR
> (television program%) OR (near((training, video%),2)) OR (near((video,
> produc%),3)) OR (near((video, program%),2)) OR (television broadcast%)
> OR (television production) OR (training tape%) OR (video broadcast%)
> OR (video documentation) OR (near((video, edit%),1)) OR (video
> operation%) OR (video
> presentation) OR (video program%) OR (video proposal) OR (video
> publication) OR (video reproduction) OR (video taping) OR (video%
> service%) OR (videotaped) OR (videotaping) OR (visitor center%) OR
> (filming) OR (near((film%, produc%),1))') > 0)
>
> The searched column is CLOB datatype. The table has 10000 records. It
> was noticed that the query doesn't return some rows that it was
> supposed to - containing 'video services' which correspond to (video%
> service%). When the query was modified to look for (video services) -
> wildcards were removed - it returned those rows.
> The query would also return those rows with wildcard in place (video%
> service%), but with amount of rows in the table cut in half (5000
> rows).
>
> Is there any kind of limit on the number of ORs in the queries or
> amount of data to be queried against?
> Are there any memory parameters to be set?
Received on Thu Nov 08 2001 - 12:13:20 CET