Re: Forcing Oracle to release locked objects

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: Sat, 16 Feb 2002 09:08:36 +0400
Message-ID: <k5qr6ukgrc7o6gdoteoqvbb959ul1ta9k1@4ax.com>

IMP Is not locking your objects... It is the server process that is spawned to do this work for you.

With time this will get resolved by PMON... But if u need to rel those locks then use the v$locked_object and v$sesion to find the stray process and kit it.

HTH On Fri, 15 Feb 2002 10:54:22 GMT, "Fulvio Catto" <f.catto_at_reply.it> wrote:

>
>I was performing an import on Oracle8i (rel. 2) DB using IMP.EXE. Before the
>import finished, it crashed leaving some objects in the DB locked.
>It was not possible to unlock them unless shutting down and restarting the
>DB.
>
>Does anyone know other means to unlock objects locked by a process (such as
>IMP) ?
>
>Thanks in advance

[Additions and Corrections Always Welcome.] Best Regards,
Ganesh R Received on Fri Feb 15 2002 - 23:08:36 CST