Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to know how long a Rollback will take

How to know how long a Rollback will take

From: Dan <daniel.ostertag_at_visaer.com>
Date: 29 Sep 2006 06:17:27 -0700
Message-ID: <1159535847.699610.29490@i3g2000cwc.googlegroups.com>


I did an import that failed to extend the UNDO segment of my database. I realize I need to use commit=y to overcome this issue. However, the database is rolling back the records it imported before hitting the error. This can take several hours.

Is there a way to determine how much longer the rolling back will take?  Is there a view or a process that I can get an idea of this?

Thanks,
Dan Received on Fri Sep 29 2006 - 08:17:27 CDT

Original text of this message

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