Re: err msg = ora - 1652 , unable to extend segment by 128 in tablespace temp.

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Thu, 21 Jan 1999 16:47:32 +0800
Message-ID: <36A6E9A4.25FA@bhp.com.au>

hpcheong_at_ncs.com.sg wrote:
>
> hi ,
>
> anyone?
>
> err msg = ora - 1652 , unable to extend segment by 128 in tablespace temp.
>
> pls help! urgent.
>
> thanks!
>
> evelyn.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Your query is probably doing a large sort...Possible remedies:

1. Coalesce your TEMP tablespace (alter tablespace temp coalesce)
2. Add more space to your TEMP tablespace - either add a datafile or enlarge an existing one...
3. Examine the query to try remove the cause of the large sort

Cheers
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"

• Salvador Dali

Received on Thu Jan 21 1999 - 02:47:32 CST