Re: ORA-00054

From: <Winnie_Liu_at_infonet.com>
Date: Mon, 21 Aug 2000 14:08:22 -0700
Message-Id: <10596.115155@fatcity.com>

In V$LOCKED_OBJECT, it will tell you who is holding the lock.

Winnie

"Gopal, Umesh" <ugopal_at_proxicom.com> on 08/21/2000 01:38:25 PM

To: oracle-l_at_fatcity.com, oracledba_at_quickdoc.co.uk cc: (bcc: Winnie Liu/HQ/ISC)

Subject: ORA-00054

Hi DBA's

I get the following error message when i try to drop a table;

drop table testtab cascade constraints;

ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified

Is there is way to check which user is holding the table ?

Thanks
Umesh

---

If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk Received on Mon Aug 21 2000 - 16:08:22 CDT