SAP Knowledge Base Article - Preview

3136216 - Query on dba_segments terminates with ORA-01652

Symptom

Issue seen during the execution of SUM in phase PREP_INIT/JOB_RSUPDTEC, but may happened in any other situation.

The dump generated:

Category              Installation Errors
Runtime Errors        DBIF_DSQL2_SQL_ERROR
Date and Time         DD.MM.YYYY HH:MI:SS

Short Text
    SQL error 1652 occurred while executing Native SQL.

What happened?
    Error 1652 has occurred on the current database connection "DEFAULT".
    Database error text: ORA-01652: unable to extend temp segment by 128 
    in tablespace PSAPTEMP
    Triggering SQL statement: "FETCH NEXT "


Read more...

Environment

  • Any SAP Product
  • Any Oracle database version

Product

SAP NetWeaver all versions

Keywords

ora-1652 tempspace temporary overflow oradict statistics stats dictionary , 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.