Regis,

The great thing about the undo, is that it's totally Oracle managed, you'll never
have to worry about rollback segs ever again.

Here is how to implement it.

1. Create a tablespace called undotbs (any other name will also do)
2. In the init.ora file set up the following

undo_management=auto
unto_tablespace=undotbs

Done - all your worries about online-ing / tuning / adding rollbacks are gone. Oracle
handles everything from here.

If you have the [ undo_management=auto ] setting in your init file and forget to
create an undotbs during database creation, Oracle will automatically create a
tablespace called SYS_UNDOTBS.

hth

Roger



Regis Biassala wrote:

> Hi Guys,
> I'd like some clarification regarding this issue:
> 1. Can you create a rbs tablespace in Oracle9i and attach rollback segment
> to it ?
> 2. What goes in the undo tablespace ?
> 3. Do we still talk about rollback segments in Oracle9i ?
> 4. Can you have both undo and Rbs tablespace ?
> 5. what the difference between unod tablespace and rbs tablespace ??
>
> Thanks
> Regis
>
> --------
> Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page