Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Removing Foreign Keys

Re: Removing Foreign Keys

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Fri, 06 Oct 2000 13:47:49 GMT
Message-ID: <39ddd7da.1379359@news.alt.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US