Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ROLLBACK tablespace needs media recovery when startup mount;
On Wed, 25 Aug 1999 08:02:48 -0400, Kenneth C Stahl
<BluesSax_at_Unforgettable.com> wrote:
>Does this mean that you dropped the SYSTEM rollback segment from the
>SYSTEM tablespace and then re-created it in another tablespace. I suspect
>that may not have been a very good idea. I was always taught that one
>should never make any changes to the SYSTEM rollback segment that is
>created when the database itself is created.
There is no way you could possibly drop a SYSTEM rollback segment, or even put it offline!
Regards,
Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)