| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: problem indexing blob with intermedia
Duane Moore wrote:
> I am having a problem when I try to create a full-text index on a BLOB
> It gives me an error of "DRG-11101: failed to open file \drgit3"
This means that the INSO filter did not run correctly. I assume you are on NT. Most of the time on NT, the problem is that ctxhx cannot detect the ORACLE_HOME. You can either set the ORACLE_HOME as a system environment variable, or wrap ctxhx. Basically, that would entail renaming ctxhx.exe, and creating a shell script called ctxhx that sets ORACLE_HOME then passes all arguments to the real ctxhx.exe. These should all be in $ORACLE_HOME\ctx\bin.
> The index works okay when I use a CLOB text column.
> Any ideas on why the index on the BLOB column would not work?
When you index a BLOB, iMT by default assumes that these are formatted documents and uses the INSO filter. For CLOB, it assumes no filter is needed, since it is already character data.
> (I have also tried it with BFILEs and get roughly the same problem).
Same thing for BFILE.
--
 |
 |