Re: very long sqlplus query with implicit view

From: <michael_bialik_at_my-deja.com>
Date: Thu, 02 Dec 1999 19:25:54 GMT
Message-ID: <826h38$nhe$1@nnrp1.deja.com>

Hi.

Usually you have that error when the total length of sort fields ( mentioned in GROUP BY, ORDER BT, etc ) exceeds the db block size. Try to rewrite you query avoiding sort.

HTH. Michael.

In article <826avb$ing$1_at_nnrp1.deja.com>, Screamin' Johnny <jrehg_at_yahoo.com> wrote:
> Hi!
>
> I am trying to generate a sqlplus report using an implicit view in my
> from clause and keep getting an error message:
> sort key too long and error # ora 01467
> for which I can find no documentation.
>
> I am thinking of creating some temporary views and was wondering if
> this would resolve the problem.
>
> Any help would be greatly appreciated!
>
> --
> Thanks,
> The Wild Man
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 02 1999 - 13:25:54 CST