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

May be you should create a separete tablespace TEMP specially for sorting
and change the default TEMPORARY_TABLESPACE to TEMP instead of using
SYSTEM.


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

Quote:

>Hi:

>I got the following error. What should I do?

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

>--
>Best regards,

Your user/process is trying to create temporary space for a large sort,
creating an index or something. This is going into the system tablespace
(yuck).  Get the temporary stuff out of system and into a seperate temp
tablespace.

If you have a temporary tablespace:

alter user <user> temporary tablespace <temp> ;

Otherwise, create a temporary tablespace and do the above.  As a last resort
add more space to the system tablespace.

alter tablespace system
add datafile '<datafile spec>'
/



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

Thank you very much for all of your input.

The problem is one of the user was created with default tablespace =
SYSTEM. So I have changed it and just work fine.

Best regards,

: May be you should create a separete tablespace TEMP specially for sorting
: and change the default TEMPORARY_TABLESPACE to TEMP instead of using
: SYSTEM.


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

--
Best regards,



Fri, 01 Jun 2001 03:00:00 GMT
 
 [ 7 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