Re: Need DBA's help

As another poster says, don't mess with anything in the SYS schema except under the instruction of Oracle support. The only thing Oracle authorizes a user to touch in SYS is the audit$ table.

According to Jonathan Lewis, sort key too long is caused by "the sum of the maximum sizes of the columns in the indexes is greater than approx 1/3 of the Oracle block size". But since this is in SYS, don't do anything unless you just want to learn Oracle internals on a test instance.

Yong Huang
yhuang_at_indigopool.com

Violin <violin.hsiao_at_mail.pouchen.com.tw> wrote in message news:39cad895.3810048_at_172.16.7.5...
> I try to issue ALTER INDEX xxx REBUILD command for each index.
> After rebuilded successfully,I select dba_extents again and each index
> is less than 20 extents.
> Almost every index rebuilds successfully except for SYS.I_SOURCE1
> when i tried to :
> ALTER INDEX SYS.I_SOURCE1 REBUILD
>
> An error happens :
>
> ORA-01467 : sort key too long
Received on Fri Sep 22 2000 - 14:50:21 CDT