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 -> Forcing Oracle to release locked objects

Forcing Oracle to release locked objects

From: Fulvio Catto <f.catto_at_reply.it>
Date: Fri, 15 Feb 2002 10:54:22 GMT
Message-ID: <yN5b8.22971$tv6.654957@twister1.libero.it> 






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


--
Fulvio Catto


Received on Fri Feb 15 2002 - 04:54:22 CST












Original text of this message













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