temporary segment

From: Uppal, Inde <Inde.Uppal_at_chelwest.org>
Date: Thu, 27 Apr 2000 10:08:57 +0100
Message-Id: <10480.104261@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFB028.5DE09826
Content-Type: text/plain;

charset="iso-8859-1"

Hi
Running Oracle 8.0.5 on NT. There was an export running as system, which hung (should have taken 40 mins and was still going 12 hours later!). I killed the session, but it is still being shown in top sessions (as killed), and there is a temporary segment in the temp tablespace which hasn't been cleaned up. It has been sitting there for the last 48hours.

Inde Uppal
Oracle DBA
System Support

This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice of its status. Please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any other person: to do so could be a breach of confidence. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of the Trust. Thank you for your co-operation.

------_=_NextPart_001_01BFB028.5DE09826
Content-Type: text/html;

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>temporary segment</TITLE>
</HEAD>
<BODY>

Hi
 Running Oracle 8.0.5 on NT. There was =
an export running as system, which hung (should have taken 40 mins and = was still going 12 hours later!). I killed the session, but it is still = being shown in top sessions (as killed), and there is a temporary = segment in the temp tablespace which hasn't been cleaned up. It has = been sitting there for the last 48hours.

Inde Uppal
 Oracle DBA
 System Support

 
 

This e-mail is confidential and may =
well also be legally privileged.  If you have received it in = error, you are on notice of its status. Please notify us immediately by = reply e-mail and then delete this message from your system. Please do = not copy it or use it for any purposes, or disclose its contents to any = other person: to do so could be a breach of confidence. Any views = expressed in this message are those of the individual sender, except = where the sender specifically states them to be the views of the = Trust.

 Thank you for your =
co-operation. Received on Thu Apr 27 2000 - 04:08:57 CDT