SAP Knowledge Base Article - Preview

2856730 - ORA-01652 on non-temporary tablespace (i.e. PSAPSR3)


This issue may occur in several different situations, but the error will be:

ORA-01652: unable to extent temp segment by 8192 in tablespace <tablepace_name>

The most important to confirm this is the issue is that the referred <tablespace_name> is not an actual temporary tablespace. It may happen even for PSAPTEMP in case it was created incorrectly.



  • Any Oracle RDBMS version
  • Any OS platform
  • Any SAP product


SAP NetWeaver 7.0


tmp temp fail error oracle psaptemp psapsid tabspace table space issue , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.