ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Posted on 2004-09-30
We are getiing this ORA error when we are performing a high volume task(search, sort, grouping, insertion of more than 4 million records). We are creating LMT. The current default TEMP TS size is set to 18G. We are using Oracle 184.108.40.206 on SPARC Sun Solaris OS 5.8. would appreciate an early response as this is a show stopper.
P.S: Am assigning all the points that I have currently, sorry about it being low.