SAP Knowledge Base Article - Preview

2546548 - SPAM/SAINT Error with ORA-25153: Temporary Tablespace is Empty

Symptom

Update using SPAM or SAINT stuck in IMPORT_PROPER phase.

Step: MOVE NAMETABS

Error can be checked from DIR_TRANS/P<date>.<SID>

Logs will contain error as below:

13:23:50: Retcode 1: error in DDL statement for PATHISTORY - repeat
Error 25153-ORA-25153: Temporary Tablespace is Empty when executing ADD-FIELD of
Error PATHISTORY when executing ADD-FIELD of
 DB-ROLLBACK()
No DDL commands found for activation of PATHISTORY

OR

2WETP000 10:53:54: Retcode 1: error in DDL statement for "PAT05                         " - repeat
2EETP345 10:54:06: Retcode 1: SQL-error "25153-ORA-25153: Temporary Tablespace is Empty" in DDL sta
2EETP345 tement for "PAT05                         "
2 ETP000  --------------- DB-ROLLBACK() ---------------
2EETP334 10:54:06: error in DDL, nametab for "PAT05" not activated


Read more...

Environment

  • SPAM/SAINT
  • Oracle
  • SAP Netweaver AS ABAP

Product

SAP NetWeaver all versions

Keywords

Tablespace, ORA-25153, 25153, SPAM, SAINT, NAMETAB, MOVE NAMETAB, IMPORT_PROPER, PSAPTEMP, Temporary Tablespace is Empty when executing ADD-FIELD, PATHISTORY, PAT05, stopping on error 8 during MOVE NAMETABS, Error, PAT106-PATCH, SAPMSPAM, LSPAMTOP, Field "PAT106-PATCH" is unknown , KBA , BC-UPG-OCS-SPA , Support package tools for ABAP , 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.