No, it's just one table...
--
Fulvio Catto
@logistics Reply s.r.l.
Via Ripamonti, 89
20139 Milano
f.catto_at_reply.it
www.reply.it
"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message
news:3c701d61_2_at_mk-nntp-1.news.uk.worldonline.com...
> These 'objects'. Are they snapshots by any chance?
>
> Paul
>
> "Fulvio Catto" <f.catto_at_reply.it> wrote in message
> news:LvRb8.11275$8F6.536385_at_twister2.libero.it...
> > I thank you for your answer but the problem is a bit more complex...
> >
> > The fact is that the session is already marked for killing (and in fact
> its
> > status is 'KILLED'), but objects are still locked.
> > Maybe Oracle tries to gently finish the transaction before releasing
> locked
> > objects? If so, it won't never succeed in this because the session does
> not
> > exist anymore...
> > After three (!) days the session status was still 'KILLED' and objects
> still
> > locked.
> >
> > I still can't explain it to me...
> >
> > --
> > Fulvio Catto
> > @logistics Reply s.r.l.
> > Via Ripamonti, 89
> > 20139 Milano
> > f.catto_at_reply.it
> > www.reply.it
> >
> > "Ganesh Raja" <ganesh_at_gtfs-gulf.com> wrote in message
> > news:k5qr6ukgrc7o6gdoteoqvbb959ul1ta9k1_at_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 Tue Feb 19 2002 - 11:44:43 CST
