Re: Data in TEMP tablespace is never cleared
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 7 Dec 2001 09:33:52 -0000
Message-ID: <3c108cf1$0$232$ed9e5944_at_reading.news.pipex.net>
Date: Fri, 7 Dec 2001 09:33:52 -0000
Message-ID: <3c108cf1$0$232$ed9e5944_at_reading.news.pipex.net>
[Quoted] There is an article on exactly this problem at the FAQ available at http://www.jlcomp.demon.co.uk/faq/fulltemp.html
[Quoted] A full temp tablespace should definitely not make the database unusable. Note that your application should not be trying to reate permanent segments in a temp tablespace. Also the temp tablespace data(or better yet temp)files should not be set to autoextend so as to avoid filling the disk.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Rick Denoire" <100.17706_at_germanynet.de> wrote in message news:82qv0uom4lff17q0q9v78kt5ns5mccrr44_at_4ax.com...Received on Fri Dec 07 2001 - 10:33:52 CET
> Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:
>
>
> >
> >Which means it won't be cleared except with restarting the database.
>
> Could you please elaborate on that? Do you mean that it is "normal"
> for the TEMP tablespace to be left full? So under which circumstances
> is this expected to happen? There hould be a way to avoid that, since
> a full TEMP tablespace makes the DB unfunctional!
>
> Thanks
>
> Rick
>