Re: ORA ERROR 1467

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: Fri, 17 Aug 2001 09:11:47 -0700
Message-ID: <tvbf7.131$8x6.27143@inet16.us.oracle.com>

Look up the error message in the Oracle documentation, or do an oerr ora 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" <mpm966_at_yahoo.com> 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

Received on Fri Aug 17 2001 - 11:11:47 CDT