Hi:

I got the following error. What should I do?

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

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

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>'
/

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,