Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP: Unable to rebuild index

Re: HELP: Unable to rebuild index

From: sganesh <sganesh_at_apple.com>
Date: 23 May 1999 21:27:14 -0500
Message-ID: <3748aaf2@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 Sun May 23 1999 - 21:27:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US