Re: Adding rollback

From: Dave <david.sharples3_at_ntlXworld.com>
Date: Mon, 16 Aug 2004 23:07:18 GMT
Message-ID: <G6bUc.748$Sw6.399@newsfe3-gui.ntli.net>

"bw" <bunjibry_at_gmail.com> wrote in message news:b78d5a20.0408161258.50fa03e_at_posting.google.com...
> 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?

you sure you arent using undo?

show parameter undo Received on Mon Aug 16 2004 - 18:07:18 CDT