What causes the error "ORA-01652: Unable to extend temp segment" in StarTeam 2008 R2 Server log?

0 Likes

Problem:

What causes the error "ORA-01652: Unable to extend temp segment" in StarTeam 2008 R2 Server log?

Resolution:


  • Product Name: StarTeam
  • Product Version: 2008 R2
  • Product Component: Server
  • Platform/OS Version: Windows 2003

This error indicates that the TEMP tablespace in your StarTeam Oracle database has reached its capacity. StarTeam 2008 R2 is expected to utilize more temp space than previous versions due to changes in how it performs large sorting operations. In previous versions StarTeam used do the sorting of the data internally however now it leaves the sorting to the database and then it streams it over to the server to utilize.

Although this helps with the StarTeam Server performance it does require a larger TEMP tablespace in Oracle therefore to resolve this error allocate more space in Oracle. Determining what size it should be will require some investigating by your DBA and may involve a trial and error approach.


Old KB# 30284
Comment List
Related
Recommended