Home » SQL & PL/SQL » SQL & PL/SQL » acquired nowait
acquired nowait [message #252238] Wed, 18 July 2007 05:06 Go to next message
geetika_bansal
Messages: 2
Registered: July 2007
Junior Member
how to remove lock acquired nowait resource
Re: acquired nowait [message #252253 is a reply to message #252238] Wed, 18 July 2007 06:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think you refer to the error you get on a DDL.
You have to wait the transactions that hold the locks commit or rollback.

Regards
Michel
Re: acquired nowait [message #252255 is a reply to message #252253] Wed, 18 July 2007 06:52 Go to previous messageGo to next message
geetika_bansal
Messages: 2
Registered: July 2007
Junior Member
i am getting this error when i was trying to modify a column in a table.how can i write the alter statement
Re: acquired nowait [message #252264 is a reply to message #252255] Wed, 18 July 2007 07:27 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post the statement.
Better copy and paste the screen.

And don't forget:
Read and follow How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS
Make sure that lines of code do not exceed 80 or 100 characters when you format.
Please always post your Oracle version (4 decimals).

Regards
Michel
Previous Topic: CONCAT & SQL (to display rows into columns)
Next Topic: SQL
Goto Forum:
  


Current Time: Sun Dec 04 04:36:45 CST 2016

Total time taken to generate the page: 0.10073 seconds