ora-1450 even though max key length is well below the max

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Wed, 21 Jun 2006 21:01:13 GMT
Message-ID: <tsimg.26522$YI2.4641@trnddc01>

I'm getting this error however the maximum key length computed by adding the length() of all columns in the index + the rowid, length, and column separator bytes is not even half what oracle says should be the max (3118) for my block size (8k). Anyone know whats going on?

Platform = Solaris 10
Oracle Version = 9.2.0.6.0
db_block_size = 8k
indx tablespace block size is also 8k

The index is defined as follows...

CREATE UNIQUE INDEX DIM_LOCAL_U1 ON DIM_LOCAL   (LOGDATE, URI, REFERRER)
  TABLESPACE indx
  COMPRESS 2 The columns are defined as follows...
logdate DATE
uri varchar2(2000)
referrer varchar2(2000)

Max key length is only 1435 bytes and well below the max of 3118 as determined with the following query...

SELECT MAX(LENGTH(logdate)+LENGTH(uri)+LENGTH(referrer)+12) keylen FROM DIM_LOCAL; Received on Wed Jun 21 2006 - 16:01:13 CDT