unable to take rollback segment offline

From: Indra Harimurti <indra_at_sofrecom.co.id>
Date: Wed, 23 Aug 2000 16:06:15 +0700
Message-Id: <10598.115332@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_000A_01C00D1C.10C27A40 Content-Type: text/plain;

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

Dear List,

Oracle 7.3.4 Digital Unix 4.0d
try to make rollback segment offline but always failed even after the instance is restarted.

have done these steps :

1. restart the database
2. exclude in init.ora=20
3. check using : select name,xacts       =20
    from v$rollname,v$rollstat         =20

where status =3D 'PENDING OFFLINE' =20 and v$rollname.usn=3Dv$rollstat.usn; No Rows Selected

but STILL it can not be put offline, what else need to be done ? Please help. Thanks

Indra =20

------=_NextPart_000_000A_01C00D1C.10C27A40 Content-Type: text/html;

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>

<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000000 size=3D2>Dear List,</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>Oracle 7.3.4 Digital Unix =
4.0d</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>try to make rollback segment offline =
but=20
always</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>failed even after the instance is=20
restarted.</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>have done these steps :</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>1. restart the database</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>2. exclude in init.ora </FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>3. check using : select=20
name,xacts        =
<BR>    from=20

v$rollname,v$rollstat        &nbs= p;=20
<BR>    where status =3D 'PENDING =
OFFLINE'   =20
<BR>    and v$rollname.usn=3Dv$rollstat.usn;</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>    No Rows =
Selected</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>but STILL it can not be put offline, =
what else=20
need to be done ?</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>Please help. Thanks</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>Indra  =
<BR></FONT></DIV></BODY></HTML>
Received on Wed Aug 23 2000 - 04:06:15 CDT