Taking rollback segements offline

From: Mr. Majestic <rc_at_neomenia.com>
Date: Mon, 19 Jun 2000 10:29:01 -0400
Message-Id: <10533.109710@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0007_01BFD9D9.2F71EFF0 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

What would happen if you took a system rollback segment off line? When would you take a system rollback segment offline? **** What should I know about rollback segments to not destroy the = database?

to experiment, I plan to execute this statement

spool c:\result.sql

select distinct 'ALTER ROLLBACK SEGMENT '|| segment_name ||' OFFLINE;' from dba_rollback_segs where=20
segment_name not IN ('SYSTEM', 'TEMP');

@c:/result.sql
spool off

------=_NextPart_000_0007_01BFD9D9.2F71EFF0 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>What would happen if you took a system =
rollback=20
segment off line?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>When would you take a system rollback =
segment=20
offline?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>**** What should I know about rollback =
segments to=20
not destroy the database?</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>to experiment, I plan to execute this=20
statement</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>spool c:\result.sql</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>select distinct 'ALTER ROLLBACK SEGMENT =
'||=20
segment_name ||' OFFLINE;'<BR>from dba_rollback_segs where =
<BR>segment_name not=20

IN ('SYSTEM', 'TEMP');</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>@c:/result.sql<BR>spool=20
off</FONT></DIV></BODY></HTML> Received on Mon Jun 19 2000 - 09:29:01 CDT