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

On Thu, 22 Jun 2006 15:39:50 GMT, Chuck <skilover_nospam_at_bluebottle.com> wrote:
> Does anyone around here read? I'll say it one last time... this works in
> a 9205 instance with the exact same DDL. If as you say it's based on the
> max defined width of the varchars how does this work on 9205?

It doesn't work for me:

SQL> select * from v$version where rownum <= 2; Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production PL/SQL Release 9.2.0.5.0 - Production

SQL> create table test_tab (c1 varchar2(4000), c2 varchar2(4000)); Table created.

SQL> create index test_idx on test_tab(c1, c2); ORA-01450: maximum key length (6398) exceeded

-- 
Matthew Winn
[If replying by email remove the "r" from "urk"]