Re: Adding rollback

From: Mark Bole <makbo_at_pacbell.net>
Date: Thu, 19 Aug 2004 00:33:00 GMT
Message-ID: <0zSUc.4551$QJ3.1843@newssvr21.news.prodigy.com>

Howard J. Rogers wrote:

> bw wrote:

>>"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message
>>news:<41221dde$0$3928$afc38c87_at_news.optusnet.com.au>...
>>
>>>Daniel Morgan wrote:
>>>>Howard J. Rogers wrote:
>>>>>Daniel Morgan wrote:
>>>>>>bw wrote:
>>>>>>>I have inherited a 9.2.0 database where the only rollback segments
>>>>>>>that exist are what was created for SYSTEM.  Can I get away with
>>>>>>>adding the needed rollback segments (RBS01... etc.) to the init.ora,
>>>>>>>creating them in the existing RBS tablespace?  Once this has been
>>>>>>>completed do I then bounce the instance so they are recognized via
>>>>>>>the init.ora?
>>>>>>

[...]
> Far, far easier than any of that old nonsense, however, is:
>
> create undo tablespace RBS datafile '/etc/etc/etc' size whatever;
>
> And then: UNDO_MANAGEMENT=AUTO
> UNDO_TABLESPACE=RBS
>
> There's no reason NOT to use automatic undo. There's every reason to do so.
>
> Regards
> HJR
Amen. The move from RBS to automatic undo with 9i has reduced my nuisance busywork by about 10%, YMMV.

This is one of many reasons why exporting/importing from 8i to 9i was much more productive than "migrating" in place ... the incentive to use the new stuff and discard the deprecated stuff is much higher when you are creating the new databases from scratch.

--Mark Bole Received on Wed Aug 18 2004 - 19:33:00 CDT