Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Sort Key Too Long while REBUILDING INDEX
I looked on the web and it appears that there is some kind of buy in
Oracle 7.1*, but we have 7.3, and it seemed like that that bug was
related to varchar2(2000). Any ideas? Thanx
SVRMGR> ALTER INDEX base_free.xaction_when_xacted REBUILD TABLESPACE
BASFREEIND STORAGE (INITIAL 250M NEXT 50M);
ALTER INDEX base_free.xaction_when_xacted REBUILD TABLESPACE
BASFREEIND STORAGE (INITIAL 250M NEXT 50M)
*
ORA-01467: sort key too long
Table on which the index is built
SVRMGR> desc base_free.xaction
Column Name Null? Type ------------------------------ -------- ---- ID NOT NULL NUMBER(8) USER_ID NUMBER(8) PLAYER_ID NUMBER(5) PRICE NOT NULL NUMBER(10) DROP_V_ADD NOT NULL NUMBER(1) WHEN_XACTED NOT NULL DATESVRMGR> Received on Mon Jul 26 1999 - 10:34:03 CDT
![]() |
![]() |