Re: Data in TEMP tablespace is never cleared

Is there a specific Ora error you are receiving? I have run into a similar situation at work with non-dictionary managed temp tablespaces that were set to permanent.

Ken

"Rick Denoire" <100.17706_at_germanynet.de> wrote in message news:8u041ukm64m1j7almilpjdaumis6nqe57h_at_4ax.com...
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote:
>
> >There is an article on exactly this problem at the FAQ available at
> >http://www.jlcomp.demon.co.uk/faq/fulltemp.html
>
> All right, I read it.
>
> >A full temp tablespace should definitely not make the database unusable.
>
> In this case, the application fails and complains about not being able
> to extend space in TEMP. This is in clear contradiction to what you
> said. The DB is, of course, not "unusable", but THIS query won't run
> OK.
>
> Could it be that a particular query needs a minimum amount of space in
> TEMP to run through? So should I try to enlarge TEMP? (Originally, it
> was 8 GB, now it is 24 GB in size, the query still fails).
>
> Thanks
>
> Rick
>
Received on Tue Dec 11 2001 - 01:26:52 CET