Re: ORA-01450

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 22 Jul 1999 16:25:35 +0100
Message-ID: <932657466.4860.0.nnrp-13.9e984b29@news.demon.co.uk>

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