SAP Knowledge Base Article - Preview

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

Symptom

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.


Read more...

Environment

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

Product

SAP NetWeaver 7.0

Keywords

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.