Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-02014
"misha" <mikhail888_at_mail.ru> schrieb im Newsbeitrag
news:d37f2f47.0205300749.6838ee56_at_posting.google.com...
> i'm getting
>
> ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY,
etc.
>
> when I do
>
> select N
> from TABLE
> where STAT = 1 for update nowait;
>
> now, TABLE is not a view but a valid table
>
> if I do
>
> select N
> from TABLE
> where SOMEOTHERFIELD = 1 for update nowait;
>
> it works fine; is it an oracle bug? please help
>
> I have Oracle 9i on Win2k.
It would be helpful if you show us the table definition, what indexes are defined etc.
Regards,
Knut Received on Fri May 31 2002 - 03:35:18 CDT