Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> how to release row lock?

how to release row lock?

From: Kenneth Yue <cwyue_at_se.cuhk.edu.hk>
Date: 4 Oct 1999 04:38:31 GMT
Message-ID: <7t9b07$hlo$1@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 Sun Oct 03 1999 - 23:38:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US