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 -> Rollback segment question

Rollback segment question

From: Tapan Trivedi <tapan.trivedi_at_abbnm.com>
Date: Mon, 02 Aug 1999 15:33:40 -0500
Message-ID: <37A600A4.938647BC@abbnm.com>


Hey gurus,
 I have an index which is causing me problems and I have to rebuild. The index is on a very a large table.
 I am afraid I do not have a big enough Rollback segment to complete the operation. So I will have to create a new Rollback Segment and do a   set transaction use rollback segment

My problem is how do I estimate how big a rollback segment will the transaction require ? Any ideas , experiences will be appreciated.

                                 Tapan H Trivedi
Received on Mon Aug 02 1999 - 15:33:40 CDT

Original text of this message

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