OraFAQ Forum: Forms » ORA-00054: resource busy and acquire with NOWAIT specified

Home » Developer & Programmer » Forms » ORA-00054: resource busy and acquire with NOWAIT specified

Mon, 05 June 2006 06:54

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

Hii all

i try to drop a table by this syntax

Quote:

drop table GIMCADTXX;

and i got that error

Quote:

ORA-00054: resource busy and acquire with NOWAIT specified

Thnaks for everyone helped and helping me

Mon, 05 June 2006 07:42

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

00054, 00000, "resource busy and acquire with NOWAIT specified"
// *Cause:  Resource interested is busy.
// *Action: Retry if necessary.

Someone is using that table, so you cannot drop it.

Some workarounds, try again later, kill those users or restart the database in restricted mode.

Previous Topic:	VISSUAL ATTRIBUTE
Next Topic:	COMPILING FORMS FROM THE COMMAND LINE

Goto Forum:

]

Current Time: Thu May 14 09:52:17 CDT 2026