Re: Complex CONTEXT index
Date: Mon, 26 Jan 2009 10:32:00 +0100
Rich Jesse wrote:
>>Don't you need to translate the BLOB content into indexable text before you
>>index it? A simple transliteration of hex values is no help; you need
>>something that would convert the enclosed encoded Word or PDF into real
>This is exactly what Oracle's Ultrasearch does. I've used it in the past
>(10gR1) to power an Intranet search site that crawled Intranet sites as well
>as file shares. It indexes very well, grabbing text from every popular
>format including binary MS documents, PDFs, drawings, as well as the headers
>in images and video files. But it wasn't the most stable. I needed to
>bounce it regularly, at least monthly, IIRC.
>Perhaps it's better with 10gR2 or 11g, if it's still available.
maybe not exactly what the OP is looking for, but why concatenate the different columns manually?
You can us the MULTI_COLUMN_DATASTORE to create a virtual document for each record.
I used it with VARCHAR2 and BLOB's as well as CLOB's. Please see link below for details:
Have a nice day
Received on Mon Jan 26 2009 - 03:32:00 CST