Home » SQL & PL/SQL » SQL & PL/SQL » lock table (2 Merged) (oracle database 11g)
lock table (2 Merged) [message #585080] Tue, 21 May 2013 21:50 Go to next message
Messages: 98
Registered: July 2011
Location: Iran
dear members.
I want to lock some table after I update a many rows for a session and after the transaction unlock those table.would please guide me how to do that.
thank you.
Re: lock table [message #585082 is a reply to message #585080] Tue, 21 May 2013 22:05 Go to previous messageGo to next message
Messages: 25571
Registered: January 2009
Location: SoCal
Senior Member
You should maintain at least 2 meters separation between you and any keyboard until after all of these crazy thoughts no longer exist in your head.

Why do you want to devolve the application into single user mode by taking explicit locks on any table?
Re: lock table (2 Merged) [message #585086 is a reply to message #585080] Wed, 22 May 2013 00:13 Go to previous messageGo to next message
Michel Cadot
Messages: 65143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is actually not clear what you have and want.
Post an example.

Re: lock table (2 Merged) [message #585092 is a reply to message #585086] Wed, 22 May 2013 00:47 Go to previous message
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
LOCK TABLE might be what you are looking for.
Previous Topic: Create Index on Multiple tables
Next Topic: please help,Error(15,22): PLS-00382: expression is of wrong type
Goto Forum:

Current Time: Sat Aug 19 10:06:38 CDT 2017

Total time taken to generate the page: 0.10642 seconds