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 SEG6460Received on Sun Oct 03 1999 - 23:38:31 CDT