Re: How to know how long a Rollback will take

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 30 Sep 2006 13:44:15 -0700
Message-ID: <1159649054.953555.57970@e3g2000cwe.googlegroups.com>

Sybrand Bakker wrote:
> On 29 Sep 2006 07:14:48 -0700, "Dan" <daniel.ostertag_at_visaer.com>
> wrote:
>
> >One other question. This happened during an import and I do not want
> >or need the data that is being rolled back. I could drop/recreate the
> >table entirely and discard all previous data and rollback data. Is
> >there a way to just 'pull the plug' on the rollback and stop it
> >entirely? Is so, what are the risks?
>
> Please do not top post.
>
> You can't drop the table as it is involved in a transaction.
> Even if you issue shutdown abort in sql*plus, Oracle will perform
> crash recovery, and it will restart the rollback.
>
>
> The only thing you can do is sit back and take some more coffee.
>
> --
> Sybrand Bakker, Senior Oracle DBA

Dan, thank you. As Sybrand said you need to wait out the rollback.

HTH -- Mark D Powell -- Received on Sat Sep 30 2006 - 15:44:15 CDT