Re: Data in TEMP tablespace is never cleared

[Quoted] "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 Sat Dec 08 2001 - 13:12:58 CET