Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01450
Yes, rebuild the database with a bigger block size. The maximum length for the sum of the column storage sizes for an index is a bit less than half the block size.
You might review the need for such an index though - is it a multi-column index holding lots of parent/child information, and could you switch several of those columns into a single meaningless integer at some point in the family tree ?
--
Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk
Christophe BREGAND wrote in message <3797152B.53BB_at_elca-matrix.ch>...
>When I'm trying to create a (very long) unique index, I catch the
>ORA-01450 error: "maximum key length (758) exceeded".
>I'm using Oracle 7.3.4 for Solaris.
>Is there a solution to change this value (758)?
>Thank you.
Received on Thu Jul 22 1999 - 10:25:35 CDT