> Dear gurus !
> I have killed a session while it was populating a big table.
> Now the session is marked KILLED in v$session.
> It's serial# is keeping being incremented , so i assume that a rollback
> (of rows inserted into that big table by that session) is going on there
> in the background.
> This rollback runs for several hours already preventing me from DMLing
> that big table.
> Is there a way to stop that rollback / drop / truncate that table ?
> Thanks a lot in advance .
> Andrey.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrey Bronfin
INET: andreyb_at_elrontelesoft.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Aug 07 2001 - 03:54:51 CDT
