Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01652: unable to extend temp segment by 1598 in tablespace

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

From: Francis Wong <fwong_at_globalserve.net>
Date: 13 Dec 1998 22:55:59 GMT
Message-ID: <01be2622$127e1930$1b865ad1@francis> 





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




suisum_at_ecn.ab.ca wrote in article <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,


> 


Received on Sun Dec 13 1998 - 16:55:59 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US