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

From: Raymond <mghong_at_pl.jaring.my>
Date: Mon, 28 Dec 1998 07:30:20 GMT
Message-ID: <3687337c.1947616@nntp.jaring.my>

On 13 Dec 98 20:38:30 GMT, suisum_at_ecn.ab.ca () wrote: But even I had 1 gig of temporary tablespace call TEMPORARY , I can easily be fragmented by 1 days. , becoz of every commit, swap , ,select statement right ,

I just recreate my temporary to 1gig after I had check it is fully fragmentated , but what I get is a more slower system , Currently we are running a raid 5 system with about 25 gig hardisk slice into 12 slices..

>Hi Thomas:
>
>You are really really helpful. The answer are precise and applicable as
>usual. I have fixed the problem.
>
>Thanks a lot for your great help.
>
>Best regards,

>
>: 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'
>
>:
Received on Mon Dec 28 1998 - 01:30:20 CST