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

From: Alan Way <alanw_at_poservices.co.nz>
Date: Mon, 14 Dec 1998 11:23:37 +1300
Message-ID: <o7Xc2.35$LO.905@news.clear.net.nz>

suisum_at_ecn.ab.ca wrote in message <367324b9.0_at_ecn.ab.ca>...
>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>'
/ Received on Sun Dec 13 1998 - 16:23:37 CST