Re: UNLOCK TABLE

From: Andy Carruthers <acarruthers_at_notegate.vnu.co.uk>
Date: Wed, 03 Jun 1998 12:39:03 +0000
Message-ID: <357543E7.2F9F@notegate.vnu.co.uk>

Kannan M wrote:
>
> Is there any thing to UNLOCK a table b'cos its locked by an indefinite loop
> ?

Several ways spring to mind (depending upon OS and Oracle version)

For Unix, find the process and shadow process that are running and kill -15 them, (kill -9 if that fails, which is messy).

In Oracle, if you have access to SQL*DBA then monitor locks and break the appropriate lock.

Once the lock is broken, find out what caused it before running the same process.

If there is no offending process, then you may need to shutdown and restart the database.

Andy Received on Wed Jun 03 1998 - 07:39:03 CDT