SAP Knowledge Base Article - Preview

3136216 - Query on dba_segments terminate 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 for Me (Login required).

Search for additional results

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