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

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

--
Best regards,



Thu, 31 May 2001 03:00:00 GMT
 ORA-01652: unable to extend temp segment by 1598 in tablespace


(if that email address didn't require changing)

Quote:
>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

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.



Thu, 31 May 2001 03:00:00 GMT
 ORA-01652: unable to extend temp segment by 1598 in tablespace
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,  


: (if that email address didn't require changing)

: >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.



Thu, 31 May 2001 03:00:00 GMT
 ORA-01652: unable to extend temp segment by 1598 in tablespace
|
| Hi I got the following error. What should I do?
|
| ORA-01652: unable to extend temp segment by 1598 in tablespace SYSTEM

I got a similar error message today, numbered ORA-01654 I believe.
The only difference was that it said 'index <indexname>' instead of
'temp segment'.

If you'll have a look at the Oracle documentation, each message is
listed with a description and recommended action.  The action
recommended for my error message was to add another data file to my
tablespace.  Perhaps your error has a similar fix.

--
Fred Johansen  <http://www.pvv.org/~fredj/>



Fri, 01 Jun 2001 03:00:00 GMT
 ORA-01652: unable to extend temp segment by 1598 in tablespace

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..

Quote:
>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'

>:



Fri, 15 Jun 2001 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

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

2. ORA-01652: unable to extend temp segment by 256 in tablespace TEMP

3. ORA-01652: unable to extend temp segment by 256 in tablespace TEMP

4. ORA-01652: unable to extend temp segment by 512 in tablespace TEMP

5. ORA-01652 unable to extend temp segment by num in tablespace name

6. ORA-01653: unable to extend table MILREPO.TS_CHANGES by 1598 in tablespace

7. 01652: unable to extend temp segment

8. extend temp segment - ora 01652

9. ORA-1652: unable to extend temp segment by 7680 in tablespace

10. ORA-1652: unable to extend temp segment by 8192 in tablespace

11. ORA-01653: unable to extend table MILREPO.TS_CHANGES by 1598

12. TEMP tablespace, resizing (ORA-01652)


 
Powered by phpBB® Forum Software