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

> CREATE UNIQUE INDEX MYINDEX_U1 ON MYTABLE
> (LOGDATE, URI, REFERRER)
> COMPRESS 2;
>
> Index created.

What happens if you remove the COMPRESS clause? What happens if you use 4 columns all defined as VARCHAR2(2000)? Your example is not the same as the other examples.....

Cheers,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown