I think it has problems at around the 2GB limit as far as BLOBS and CLOBS are concerned. Are any of your docs bigger than 2GB?
It will index all popular doc formats (word, excel, ppt, pdf, blah blah) directly from a BLOB. It can automatically produce an HTML version of the stored doc (with search terms highlighted if that's your kind of thing). It can also index smaller amounts of textual infomation with a different kind of index that doesn't need syncing, which is possibly what your DBA was talking about, but this is not the limit of its power. On 1/6/06, Dave Carabetta <[EMAIL PROTECTED]> wrote: > On 1/6/06, James Holmes <[EMAIL PROTECTED]> wrote: > > Oracle Text can produce these search results, (imo) as good as Verity, > > with any other constraints you need ( e.g. conditions on the security > > column and any other clauses you want) all in one query. > > > > James, > > Does Oracle Text have limits as to the field size it can/will index? > We were looking to do some indexing with it, but our DBA said we had > to limit our fields to something like varchar2(30), which was > unacceptable. I did my own search into Oracle's online docs, but I > didn't see anything explicit. -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228682 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54