Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Removing Foreign Keys
It is possible that there is a session open and noone has hit commit. If you have any old sessions open, use commit and try again.
Brian
On Fri, 06 Oct 2000 09:12:52 -0400, 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,
Received on Fri Oct 06 2000 - 08:47:49 CDT
![]() |
![]() |