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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to unlock a table ?

Re: How to unlock a table ?

From: Dmitry E. Loginov <dmitry_loginov_at_mtu.ru>
Date: Thu, 6 Dec 2001 23:14:25 +0300
Message-ID: <9uojmn$2ma0$1@gavrilo.mtu.ru>

"Matthieu DEGLIN" <mdeglin_at_remove-me.partner.auchan.com> wrote in message news:9untu5$t08$1_at_reader1.imaginet.fr...
> Hello,
>
> I launch a SQL process that lock a table via an Unix shell:
>
> sqlplus -s usr/pwd <EOF

-- place here
whenever sqlerror rollback
> LOCK TABLE my_table IN EXCLUSIVE MODE;
> @my_process
> commit;
> quit;
> EOF
>
> My process has anormaly stopped and my_table is still locked.
>
> How can I unlock it ?
> Thanx for help.
>
> Matthieu
>
>
Received on Thu Dec 06 2001 - 14:14:25 CST

Original text of this message

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