Re: HELP: Unable to rebuild index

Did you change the column definition of any column in the index AFTER the index was created ?

The error message usually appears if you try to create an index where the sum of the maximum sizes for the columns is more
than about block-size/3.

Try this:

    create table t(v1 varchar2(20));
    create index t on t(v1);

    then alter column v1 to length 2000     (or 4000 if you have 8K blocks), then     try to rebuild the index.

If this is your problem then you have
to (a) rebuild the database with a bigger block size or (b) rebuild the table with a smaller column size in the index columns or (c) forget about that index.

--

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

Mark Mussett wrote in message <7ia2p4$ra5$1_at_lure.pipex.net>...
>I am unable to rebuild an index in my database.
>Oracle returns an error 'Sort Key Too Long'!
>
>Other than export the data from that particular table, truncate table's
>contents, and then try and adjust the storage clause for that index,
>followed by an import. Is there anything else i can do?
>
>This table has over 1.4 million rows in it!
>
>Please help, it's driving me nuts!
>
>
>
Received on Mon May 24 1999 - 14:59:23 CDT