OraFAQ Forum: SQL & PL/SQL » How to deal with ORA-04020 under Oracle 8i ?

Home » SQL & PL/SQL » SQL & PL/SQL » How to deal with ORA-04020 under Oracle 8i ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to deal with ORA-04020 under Oracle 8i ? [message #20785]

Thu, 20 June 2002 06:06

Carpenter
Messages: 2
Registered: June 2002

Junior Member

Can you help me?! Thank you very much!
with the following operation:

> create table abc(a number(10));
> create public synonym test for admin.table;
> truncate table test;

--Under Oracle 8.1.7,
> ORA-04020: deadlock detected while trying to lock
3534908767137147652653336

--Under Oracle 8.1.6
> ORA-00942: Table or view does not exist

How can I do for avoiding the Exceptions ?

Report message to a moderator

Re: How to deal with ORA-04020 under Oracle 8i ? [message #20789 is a reply to message #20785]

Thu, 20 June 2002 07:13

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

i beleive,
Truncating a synonym returns an ORA-4020 "deadlock detected' message (8.1.7 ), rather than the correct ORA-942 "table or view does not exist".(8.1.6).
you either upgrade to 9i or apply patch set 8.1.7.2

Report message to a moderator

Previous Topic:	Group by and Order by
Next Topic:	URGENT - Database Link as a variable problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 01:23:35 CDT 2024