Re: Rollback segment question

From: tmgn <tmgn_at_excite.com>
Date: Tue, 03 Aug 1999 10:24:57 -0400
Message-ID: <37A6FBB9.3AC47254@excite.com>

You need to allocate lots of TEMP Space for the Index Rebuild ..

-Thiru

Tapan Trivedi wrote:

> 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 Tue Aug 03 1999 - 09:24:57 CDT