Thanks. It appears I'm hitting a known bug, which is fixed in 8.1.6.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"James Mu" <jamesmu_ca_at_yahoo.ca> wrote in message
news:FfkM6.125459$_f3.1744121_at_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 Wed May 16 2001 - 16:17:45 CDT
