Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-1652 with autoextendable tablespace
"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.
-- Niall Litchfield Oracle DBA Audit Commission UKReceived on Mon Feb 03 2003 - 05:03:12 CST