Re: ORA-02014

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Fri, 31 May 2002 10:35:18 +0200
Message-ID: <ad7cnq$3v1$1@crusher.de.colt.net>

"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