You cannot run Rollback + UNDO concurrently

If the parameter undo_management = auto is set in your init file rollback
segments cannot be used.

You also need an undo tablespace + associated parameters etc etc !

Its all in the docs under UNDO management.

HTH

Mitch






Regis Biassala
<Regis.[Email Address Removed] To: "LazyDBA.com Discussion"
atalex.ie> <[Email Address Removed]
cc:
30/11/01 11:20 Subject: Oracle 9i undo tablespace vs rbs
tablespace





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] subscribe: send a blank email to oracledba-[Email Address Removed] 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