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

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sun, 13 Dec 1998 14:50:53 GMT
Message-ID: <367cd3c2.10376700@192.86.155.100>

A copy of this was sent to suisum_at_ecn.ab.ca () (if that email address didn't require changing) On 13 Dec 98 02:23:31 GMT, you wrote:

>Hi I got the following error. What should I do?
>
>ORA-01652: unable to extend temp segment by 1598 in tablespace SYSTEM

You should immediately:

alter every user in your database that has SYSTEM as their temporary tablespace to have some OTHER tablespace as their temporary tablespace. to find them, issue: select username from dba_users where temporary_tablespace = 'SYSTEM'
alter every user in your database whoses DEFAULT tablespace is SYSTEM to have some other tablespace. (run the above query, sustitute default_tablespace for temporary tablespace.
make sure your temporary tablespace is big enough for whatever operations you are performing. adding datafiles to it to make it big enough.

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/ -- downloadable utilities

Opinions are mine and do not necessarily reflect those of Oracle Corporation

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sun Dec 13 1998 - 08:50:53 CST