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

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

You can have a few alternatives here:

- either add a datafile to the temp tablespace;
- or resize the temp tablespace (not for Oracle7.2 or lower version);
- or alter the storage parameters of temp tablespace;
- or modify your query statements;
- or alter the user temp tablespace to another bigger one;

Choosing which one depends on situation.

John Koo
johnkoo_at_i-wave.net Received on Thu Jan 21 1999 - 17:26:33 CST