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

From: Torsten Borchert <T.Borchert_at_DeutschePost.de>
Date: Thu, 21 Jan 1999 08:42:08 +0100
Message-ID: <36A6DA50.F2845BAF@DeutschePost.de>

Hi,

2 reasons:
- Temp-tablespace to small -> make him greater

                           -> make your sorts in your SQL by another way

- many small pieces in tablespace -> alter tablespace temp coalesce;

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
Received on Thu Jan 21 1999 - 01:42:08 CST