| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> how to release row lock?
Dear all,
suppose I used a SELECT ... for update nowait statement to lock a row in a table. And, may be there are some problems with my programs that the lock is left on the server. How can I release the lock by logging in through another session?
thanks!
--
Cheers,
Kenneth (Milk Ken)
___\/ __ _____ ___ _____ The Chinese University
//////`\\\\ _( \/ )/ )__ of
|;;;;/~\\\| ( Touch me at : ) Hong Kong
(|($)-($)|) ( )
| '. | _/ cwyue_at_se.cuhk.edu.hk ) Department of Sys. Eng. &
\ O / ~~~\ kenneth.yue_at_alumni.ust.hk) Eng. Mgmt.
___/|\=/|\___ ( keyue_at_asl.com.hk ___)
/ | \\___// | \ ( ___)
| |* === | (_____)\____/\_____) Tutor of SEG6460
Received on Sun Oct 03 1999 - 23:38:31 CDT
![]() |
![]() |