Re: Rollback segment question

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Mon, 2 Aug 1999 22:56:27 +0200
Message-ID: <933627385.20354.0.pluto.d4ee154e@news.demon.nl>

alter index <index name>
unrecoverable
on 7.3 and higher

No need to create that rollback segment...

Hth,

Sybrand Bakker, Oracle DBA

Tapan Trivedi <tapan.trivedi_at_abbnm.com> wrote in message news:37A600A4.938647BC_at_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:56:27 CDT