Re: Adding rollback

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?

SELECT segment_name
FROM dba_undo_extents;

Unless this query returns no rows I'd suggest you get yourself current with the 9i and 10g docs.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)