Re: Don't understand ora-01789 error

From: James Mu <jamesmu_ca_at_yahoo.ca>
Date: Wed, 16 May 2001 00:57:09 GMT
Message-ID: <FfkM6.125459$_f3.1744121@news20.bellglobal.com>

Hi,

Maybe it is a bug, but try to setup this parameter in your initSid.ora _column_elimination_off=TRUE.

Hope this helpful!
James

Terry Dykstra <dontreply_tdykstra_at_cfol.ab.ca> wrote in message news:KeiM6.22650$Rd.3792542_at_news0.telusplanet.net...
> I have a view which contains a Union All statement. I can do 'select *
from
> myview', but when I try to do 'select col1 from myview' or 'select
count(*)
> from myview' I get error ora-01789. I don't understand what that error
> means.
>
> --
> Terry Dykstra
> Canadian Forest Oil Ltd.
>
>
Received on Tue May 15 2001 - 19:57:09 CDT