| vikhardba |
Posted: Nov 28, 2007 02:49:17 PM |
Total Post: 85
Joined: Apr, 2007
|
Hi All,
owner=A and table=abc
user unable to access a 'abc' object because it is locked . . may be due to following command:
lock table abc in exclusive mode;
How to i unlock the above mentioned object?
|
|
|
 Murtuja |
| Posted: Nov 28, 2007 11:34:18 PM |  |
|
Total Post: 814
Joined: Jan, 2006
|
The lock is released:
When the unit of work ends, unless the unit of work is ended by a COMMIT HOLD or ROLLBACK HOLD
When the first SQL program in the program stack ends, unless CLOSQLCSR(*ENDJOB) or CLOSQLCSR(*ENDACTGRP) was specified on the CRTSQLxxx command
When the activation group ends
When the connection is changed using a CONNECT (Type 1) statement
When the connection associated with the lock is disconnected using the DISCONNECT statement
When the connection is in the release-pending state and a successful COMMIT occurs
You can end the transaction by commit or rollback and also you can kill the session locking your table.
|
|
|
|
|
| MOH_DBA |
| Posted: Nov 29, 2007 12:46:40 PM | |
|
Total Post: 124
Joined: Nov, 2007
|
You Can simply issue rollback or commit, statement.
|
|
|
|
|
| vikhardba |
| Posted: Dec 04, 2007 11:38:46 PM | |
|
Total Post: 85
Joined: Apr, 2007
|
Thanks for the response. However, without disconnecting/killing the session, i would like to unlock the table.
NOTE: Even if commit or rollback, the object is locked. Now what?
|
|
|
|
|
| MOH_DBA |
| Posted: Dec 06, 2007 07:08:15 AM | |
|
Total Post: 124
Joined: Nov, 2007
|
I use oracle 10g release 2 and i test it and the lock was released.
any lock that happended to any object, the first movement you must do to issue a commit or rollback then kill session. the commit and rollback show worked, it work with me.
check if the lock is not from another session you miss.
|
|
|
|
|
| vikhardba |
| Posted: Dec 11, 2007 04:10:54 AM | |
|
Total Post: 85
Joined: Apr, 2007
|
Thanks for your response.
|
|
|
|
|
| MOH_DBA |
| Posted: Dec 11, 2007 03:17:18 PM | |
|
Total Post: 124
Joined: Nov, 2007
|
I hope i resolve your problem that it is what i care most.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
