| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RBS in SYSTEM Ts
Furthermore, in case your undo tablespace gets busted, I think all y'all
should keep a modest secondary rollback segment configured (but only
activated for emergencies). It is still possible to get into a space
management catch-22 without this safety net, unless there is a way to
wriggle out that I haven't fathomed. I always call that puppy R0.
mwf
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Daniel W. Fink
Sent: Friday, August 06, 2004 4:44 PM
To: oracle-l_at_freelists.org
Subject: Re: RBS in SYSTEM Ts
Gabriel,
Keep the system rbs. It is usually small (assuming it is not the only one) and is considered a system object (not something I would mess around with). I don't know that there is internal code that requires the system rbs/undo segment, but I also don't know that all the internal code does not reference it. In all the hacking I've done with undo, the idea of dropping the system undo segment never crossed my mind.
Regards,
Daniel Fink
 |
 |