Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!newsfeed1.earthlink.net!newsfeed.earthlink.net!stamper.news.pas.earthlink.net!newsread1.prod.itd.earthlink.net.POSTED!not-for-mail From: "tingl" Newsgroups: comp.databases.oracle.server References: Subject: Re: Why my Temporary tablespace is always 99% full ? Lines: 16 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2720.3000 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2727.1300 Message-ID: <%0Cta.55715$ey1.5131846@newsread1.prod.itd.earthlink.net> Date: Mon, 05 May 2003 22:59:07 GMT NNTP-Posting-Host: 65.58.52.118 X-Complaints-To: abuse@earthlink.net X-Trace: newsread1.prod.itd.earthlink.net 1052175547 65.58.52.118 (Mon, 05 May 2003 15:59:07 PDT) NNTP-Posting-Date: Mon, 05 May 2003 15:59:07 PDT Organization: EarthLink Inc. -- http://www.EarthLink.net Xref: core-easynews comp.databases.oracle.server:185352 X-Received-Date: Mon, 05 May 2003 16:00:37 MST (news.easynews.com) alter tablespace ... permanent; "cpchan" wrote in message news:b95qg4$b8m15@imsp212.netvigator.com... > I don't understand why my Temporary tablespace is always 99% full even we > shut down the database for a UNIX tar backup on every 6:00 am. > Do I need to turn off the whole UNIX machine and then turn its power again > so that all the content of the Temporary tablespace will be cleared ? > If no, how can I clear all the content of a Temporary tablespace on an > Oracle 8i RDBMS ? > > > >