Re: ORA-02014

From: TurkBear <jgreco1_at_mn.rr.com>
Date: Fri, 31 May 2002 09:06:54 -0500
Message-ID: <mp0ffu8k64niuak7api8nms6bncai3k6m3@4ax.com>

Also check to be sure you are accessing the table and not a synonym of that name that references a view...

Use the fully qualified table ( schema.table_name) instead..

"Knut Talman" <knut.talman_at_mytoys.de> wrote:

>"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
>

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Fri May 31 2002 - 09:06:54 CDT