Tablespace PSAPTEMP Cannot Be Extended

When performing a scan in an Oracle database, the storage space in the tablespace PSAPTEMP can be too small. As a result, the scan is canceled. This problem can occur when analyzing SAP tables, customer tables or organizational structures, for example. The following error messages are displayed:

SQL error 1652 occurred while accessing table <cluster table name>.
ORA-01652: unable to extend temp segment by <size> in tablespace PSAPTEMP.

Proceed as follows to avoid this short dump:

  1. Add more storage to the tablespace PSAPTEMP.

  2. If adding more storage space to the tablespace PSAPTEMP is not sufficient, start the Kyano CrystalBridge Extractor in expert mode and disable the corresponding query.