Re: ORA-01652: unable to extend temp segment by 1598 in tablespace

From: <corey_r_swain_at_notes.seagate.com>
Date: Mon, 14 Dec 1998 23:23:33 GMT
Message-ID: <7546lj$rhq$1@nnrp1.dejanews.com>

In article <367324b9.0_at_ecn.ab.ca>,
suisum_at_ecn.ab.ca () wrote:
> Hi:
>
> I got the following error. What should I do?
>
> ORA-01652: unable to extend temp segment by 1598 in tablespace SYSTEM
>
> --
> Best regards,
>

You got more problems than just the temp segment fillling up...

first, the reason the temp segment is filling is your transaction is operating with more rows than there is space available for the transaction to do "TEMP" work. Reduce the transaction size and issue commits more frequently.

Second (AND MOST IMPORTANT!!!!) your temp segment should never be assigned in the SYSTEM tablespace!!!!! EVER EVER!!! you should change the default TEMP setting for all users to be some tablespace other than SYSTEM.

alter user USERNAME temporary tablespace TEMP;

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Dec 14 1998 - 17:23:33 CST