Re: Showstopper ORA-01467: sort key too long - PLEAAASEEE HEEELP

here's your answer...:

y2k% oerr ora 01467
01467, 00000, "sort key too long"
// *Cause:
// *Action:
y2k%

ok, maybe that didn't help...try this:

Cause Action ORA–01467 sort key too long 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. Reduce the number of columns or group functions involved in the operation.

Personally, I believe that's one hell of a view. How about if you broke it up to two seperate views?

Satar

In article <71shem$3mc$1_at_bw107zhb.bluewin.ch>,   "Eric Euerlings" <euerlings_at_swift.ch> wrote:
> Hi,
> I'm still porting from Sqlanywhere to ORACLE 7.3.3 under NT 4.0.
> Now, it looks I have a showstopper.
>

>
> The view will be created well, but when I select on it, I get this:
>
> select count(*) from v_zeugnistabelle;
> select count(*) from v_zeugnistabelle
> *
> ORA-01467: sort key too long
>
> Pleeeeaaaassse help!!!!!
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Nov 05 1998 - 15:01:08 CST