Re: Problems indexing textdata in BLOBS

From: Andreas Bergmann <ab_at_bytegate.de>
Date: 26 Sep 2001 07:00:13 GMT
Message-ID: <Xns91285C7293893abbytegatede@130.133.1.4>

Galen Boyer <galenboyer_at_hotpop.com> wrote in news:u7kunuhy8.fsf_at_verizon.net:

> On 25 Sep 2001, ab_at_bytegate.de wrote:
>

>> When I try to create an index on this column everything seems to work
>> fine, but the index remains empty.

>
> Does this help?
> http://asktom.oracle.com/pls/ask/f?p=4950:8:53637::NO::F4950_P8_DISPLAYI
> D,F4950_P8_CRITERIA:238814521769,%7Bblob%7D%20and%20%7Bindex%7D
>

unfortunately not, I started the interMedia process manually and got good results when using CLOBS or VARCHAR2 within an acceptable time.

With BLOBs the 'Index-table' (DR$...) remains empty or sometimes is filled with up to 10 rows of single characters of a strange character set. Received on Wed Sep 26 2001 - 02:00:13 CDT