Message-Id: <10480.104261@fatcity.com> From: "Uppal, Inde" Date: Thu, 27 Apr 2000 10:08:57 +0100 Subject: temporary segment 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 temporary segment

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.