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

From: <rji_at_tiaa-cref.org>
Date: Tue, 15 Dec 1998 17:02:05 GMT
Message-ID: <7564mb$foa$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,
>

As a good pratice you shouldn't be using SYSTEM tablespace for temporary segments. So, what you need to do is to create a TEMP tablespace and alter your user's temporary tablespace to use the TEMP instead of SYSTEM.

Richard

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Dec 15 1998 - 11:02:05 CST