ORA ERROR 1467
magi
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
Hieraklion
There is a bug (487957) where an index can become corrupted under heavy
concurrency and one of the symptoms is encountering an ORA-1467 during a
rebuild attempt.
The bug is fixed in Oracle8 and was also included in the 7.3.4.2 patchset
release. Even though you are on 7.3.4.4, it is possible that you encountered
this bug at an
earlier time if the index was created prior to 7.3.4.2. The only workaround
if you have encountered this bug is to drop and recreate the index. You
should not experience this error on any further rebuild attempts.
"Au revoir" from Paris
Christophe Brault
magi a écrit :
Pete Sharman
1467 at the OS prompt and you'll see this:
ORA-01467 sort key too long
Cause: A DISTINCT, GROUP BY, ORDER BY, or SET operation requires a sort key
longer than that supported by Oracle. Either too many columns or too many
group functions were specified in the SELECT statement.
Action: Reduce the number of columns or group functions involved in the
operation.
--
HTH. Additions and corrections welcome.
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
"magi" <mpm...@yahoo.com> wrote in message
news:6d973122.01081...@posting.google.com...
Trupti
"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