Actually, I met this problem few years ago. I face this problem again right now after I did the SAP IDES ERP 2005 fresh installation. When I run action “Check database” in transaction DB13, I found below warnings:

It looks like the SAP system does not recognize the mentioned tablespace.

I found many solutions on this warning.

Solution 1: Update the mentioned table, SAPSR3.TAORA and IAORA, from database level

Just connect to the database using user <sid>adm.

sqlplus /nologSQL> connect /as sysdba

Change the mentioned tablespace (PSAPES30BD, PSAPEL30BD, etc) with the standard-known tablespace, such as PSAPSR3 (it depends on the SAP version).

I use IDES of ERP 2005. So the standard-known tablespace is currently PSAPSR3.

SQL> update SAPSR3.TAORA set TABSPACE=’PSAPSR3’ where TABSPACE=’PSAPES30BD’;SQL> update SAPSR3.TAORA set TABSPACE=’PSAPSR3’ where TABSPACE=’PSAPEL30BD’;

Do also on table IAORA.

Solution 2: Update the mentioned table, SAPSR3.TAORA and IAORA, from ABAP

Solution 1 above is quite technically easy to do. But that is not something RECOMMENDED by SAP.

There’s probability to have inconsistencies between database and ABAP side.

So, I recommend updating those 2 tables from ABAP side, which can be done via transaction SE16.

Make sure we have authorization to do that.

Just go to transaction SE16 and fill the table TAORA.

Click the “Table Contents” and execute.

Select the related entry, i.e. TABART=USER2 and TABSPACE=PSAPES30BD.

Click “Change”.

Change the field TABSPACE with PSAPSR3 (depends on the SAP version).

Click “Save” and go back.

Do the above step for other tablespace and for table IAORA.