Re: ORA-1652 with autoextendable tablespace

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote:

>"Rick Denoire" <100.17706_at_germanynet.de> wrote in message
>news:am5r3vs7cocqeldq1o929hrns7edmp0sb8_at_4ax.com...
>> Why is it that I get "ORA-1652: unable to extend temp segment by 128
>> in tablespace TEMP" even if I have one file in this tablespace set to
>> autoextend?
>
>I've seen this on 817 with a locally manged temp tablespace with extent size
>smaller than the sort_area_size in use. I theorise (but haven't tested) that
>Oracle needs to sort to disk so requests (say 1mb) sort space, gets an
>extent of (say 128k) and then errors. Creating a new temp tablespace with
>extent sizes to match sort area size helped in my case. This ought to be
>provable but I don't have a test 817 instance to play with.

That seems to be a very good hint! Yes, I increased the sort area size before this error began to appear. I will try recreating the temp tablespace even without trying to verify anything.

Thanks a lot

Rick Received on Tue Feb 04 2003 - 18:07:38 CST