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

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

Report message to a moderator

Re: acquired nowait [message #252264 is a reply to message #252255] Wed, 18 July 2007 07:27 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 03 06:18:59 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.