Re: Removing Foreign Keys

It's possible it's no longer in v$access. Look at v$transaction and v$locked_object. Then look at v$session based on transaction address to find the user.

Yong Huang
yhuang_at_indigopool.com

<sybrandb_at_my-deja.com> wrote in message news:8rklk0$7ql$1_at_nnrp1.deja.com...
> 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.
Received on Fri Oct 06 2000 - 14:51:11 CDT