Re: sort key too long

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 2000/09/21
Message-ID: <969529373.7732.1.nnrp-04.9e984b29@news.demon.co.uk>#1/1

Usually this means that the sum of the maximum sizes of the columns in the indexes is greater than approx 1/3 of the Oracle block size.

To get this error when doing an index rebuild, it suggests you have created the index, then used ALTER TABLE to increase the length of a column. If this is the case you won't be able to recreate the index either.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Legend wrote in message ...


>Hello all,

>

>When I alter index xxx rebuild recovery, I got sort key too long error??

>Why?? I think I need to drop the index and recreate it again???

>

>I am on 7.3.4.5 on Solaris 2.6

>

>Thanks,

>

>Benny

>

>

Received on Thu Sep 21 2000 - 00:00:00 CDT