Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to release row lock?
Hi Kenneth
All you can do is kill the session. You can't release the locks held by another session by other means.
Regards,
Ivan Bajon, ocp
Kenneth Yue <cwyue_at_se.cuhk.edu.hk> wrote in message
news:7t9b07$hlo$1_at_eng-ser1.erg.cuhk.edu.hk...
> 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 Mon Oct 04 1999 - 06:33:56 CDT