Home » Developer & Programmer » Reports & Discoverer » MSG-01003: Errors =ORA-01652: unable to extend temp segment by 128 in tablespace TEMP (merged 6) (Oracle application 11.5.10.2 and Databae 9.2.0.7)
MSG-01003: Errors =ORA-01652: unable to extend temp segment by 128 in tablespace TEMP (merged 6) [message #497851] Mon, 07 March 2011 09:50 Go to next message
shethhansal
Messages: 1
Registered: March 2011
Junior Member
Hi All,

I am trying to run on Oracle report via Oracle Application Concurrent job. Concurrent job is completing normal but I don't get anything on print out page. In log file of this request I see message 'MSG-01003: Errors =>ORA-01652: unable to extend temp segment by 128 in tablespace TEMP'. I almost doubled the TEMP tablespace in size but still I am not able to get rid of this error message.

Can anyone help?

Thanks,
-Hansal
Re: MSG-01003: Errors =ORA-01652: unable to extend temp segment by 128 in tablespace TEMP (merged 6) [message #497906 is a reply to message #497851] Mon, 07 March 2011 14:39 Go to previous message
Littlefoot
Messages: 19809
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Triplicate it?

Did you check report query? Perhaps it is "badly" written. How does explain plan look like when you run that query in SQL*Plus?
Previous Topic: Report is bringing duplicate records in Excel
Next Topic: Oracle Reports - Template (merged)
Goto Forum:
  


Current Time: Wed Nov 26 10:54:18 CST 2014

Total time taken to generate the page: 0.12087 seconds