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 -> Re: NEWBIE - How do I remove a lock???

Re: NEWBIE - How do I remove a lock???

From: <rutha_at_my-dejanews.com>
Date: Tue, 08 Dec 1998 00:05:36 GMT
Message-ID: <74hqgf$hrl$1@nnrp1.dejanews.com>


In article <01be21f5$d12ddae0$1257dea0_at_itw004>,   "Steven Fenney" <steven.fenney_at_amcor-fibre.com.au> wrote:
> Running Oracle 7.3.6 on HP-UX 10.20.
>
> How can I remove a lock on a particular table??? What is the SQL command??
>
> Thanks ahead.
> Steve
>

From Oracle8: The Complete Reference:

"Regardless of which option you choose, the table will remain in that lock mode until you commit or rollback your transactions."

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Dec 07 1998 - 18:05:36 CST

Original text of this message

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