Re: ORA-01450 on creation of new index.

Hi,

I don't think you want a BITMAP index on a block_description field that is this size, do you? BITMAP indexes are generally used where there are a large number of records, with a few distinct values!

Also, if the where clause is as follows; where block_description like '%Fred%'
then an Index will not be used, if however the where clause is; where block_description like 'Fred%'
then the Index may be used.

Rgds
Andrew

odessa7_at_my-dejanews.com wrote:

> I am trying to create a nonunique index on a varchar2(1000) (nulls ok) column
> Here is the script:
>
> CREATE BITMAP INDEX FILTER.ITEM_DESCS_ITEMNAME_DX
> ON FILTER.ITEM_DESCRIPTIONS(block_description)
> PARALLEL
> INITRANS 2
> MAXTRANS 255
> PCTFREE 5 --changed from 10
> STORAGE (INITIAL 51200
> NEXT 77824
> PCTINCREASE 1
> MINEXTENTS 1
> MAXEXTENTS 2147483645
> FREELISTS 1)
> TABLESPACE INDX
>
> Get this error Message 1: ORA-01450: maximum key length (758) exceeded
>
> I am planning on using 'like' in my where clause on this column. Do I need an
> index at all, and if yes how can I create it?
>
> Leonid.
> oracle_at_russiantreasure.com
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Apr 27 1999 - 22:00:26 CDT