Re: Removing Foreign Keys

In article <9qjrtsgon6mpk33imdc373jbctq623ur0p_at_4ax.com>,   NeedaHoliday wrote:
> i am trying to remove a foreign key and keep getting this message. Is
> there a way to force the DROP;
>
> ora-000054 Resource Busy and acquire with NOWAIT specified
>
> Thanks,
>

Somebody is using the table. If you want to force the drop, you need to kill that session and go ahead.
Consult v$access as to who is using the table.

Regards,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.