Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Document indexing
There are several ways to do this.
1. You can load the information into a clob field.
2. You could have the information accessed via a Bfile (a read only external
file.)
Then you would use Intermedia to create an index on 1 or 2. You want to
look at the documentation on Intermedia they have several examples. It does
work.
Jim
"Peter H.M. Brooks" <peter_Brooks_at_hp.com> wrote in message
news:3B6A35A2.E6E58073_at_hp.com...
> This is probably a very easy question! I would like to use the Oracle
> 'multi-media' capability. In particular I would like to load text
> documents into Oracle to index them so that keyword and wildcard
> searches can be made. I understand that this is possible, but, it isn't
> clear to me exactly how I define the type and what syntax is required
> for the INSERT command - a file name doesn't appear to be legal.
>
> Is there a simple cookbook description of how to do this that I could
> look up somewhere?
>
> Peter
>
Received on Fri Aug 03 2001 - 00:34:10 CDT
![]() |
![]() |