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

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA ERROR 1467

Re: ORA ERROR 1467

From: Trupti <trajparia_at_hotmail.com>
Date: 23 Aug 2001 16:10:11 -0700
Message-ID: <7abe1789.0108231510.63c5dce7@posting.google.com>


mpm966_at_yahoo.com (magi) wrote in message news:<6d973122.0108170342.2b49fc9f_at_posting.google.com>...
> Hi all,
>
>
> While rebulding one index i got an error ORA-01467. Sort Key too long.
> What is this error ? Is drop and recreate the only way to eliminate this?
> i am using Oracle 7.3.4 on AIX.
>
> thanks
>
> magi

"Hi,
  I am getting this Ora-1467 error whil creating new index on one of the tables. There are only 3 columns in index key. There is another index which includes these 3 columns and 2 more columns, that index got imported successfully. However this particular index is failing. I am using Oracle 8.1.7 on Windows 2000. Any suggestions?

Thanks
Trupti Received on Thu Aug 23 2001 - 18:10:11 CDT

Original text of this message

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