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 -> Sort Key Too Long while REBUILDING INDEX

Sort Key Too Long while REBUILDING INDEX

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 26 Jul 1999 15:34:03 GMT
Message-ID: <379c7c33.4821251@news.earthlink.net>


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 DATE
SVRMGR> Received on Mon Jul 26 1999 - 10:34:03 CDT

Original text of this message

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