Re: HELP: Unable to rebuild index

From: Mark Mussett <mark.mussett_at_dial.pipex.com>
Date: Mon, 24 May 1999 19:10:30 -0000
Message-ID: <7ic4l1$m69$1@lure.pipex.net>

It's definately not temp tablespace, I have 3.7gb on TEMP. Besides i've rebuilt larger indexes (in size, not in row counts!).

So, i don't think increasing TEMP will help.

Any other suggestions?

mark

sganesh wrote in message <3748aaf2_at_discussions>...
>
>Mark,
>
>I guess your temporary tablespace is too less in the DB to which you are
trying to import.
>
>
>
>
>"Mark Mussett" <mark.mussett_at_dial.pipex.com> wrote:
>>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:10:30 CDT