ORA-01450 on creation of new index.

From: <odessa7_at_my-dejanews.com>
Date: Wed, 28 Apr 1999 02:29:03 GMT
Message-ID: <7g5rpc$1e8$1@nnrp1.dejanews.com>

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 - 21:29:03 CDT