Message-Id: <10598.115332@fatcity.com> From: "Indra Harimurti" Date: Wed, 23 Aug 2000 16:06:15 +0700 Subject: unable to take rollback segment offline 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
Dear List,
 
Oracle 7.3.4 Digital Unix = 4.0d
try to make rollback segment offline = but=20 always
failed even after the instance is=20 restarted.
 
have done these steps :
1. restart the database
2. exclude in init.ora
3. check using : select=20 name,xacts        =
    from=20 v$rollname,v$rollstat        &nbs= p;=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=20 need to be done ?
Please help. Thanks
 
Indra  =