MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE ORA-00959: tablespace does not exist

[nthsol]

Hi everybody,

I wanted to share the latest error I came across while upgrading an ERP 6.0 EhP 5 to EhP 7.

Error:

During DB cloning (from current to shadow) I got the error message:

--------------------------------------------------------------------------

Severe
error(s) occurred in phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE!

Last
error code set: Single errors (code <= 😎 found in logfile 'DBCLONE.ELG'

ERROR:
Detected the following errors:

# /oracle/R11/upg/SUM/abap/log/DBCLONE01.R11:
3 ETGCLN CREATE UNIQUE INDEX "SFW_PACKAGE~0" ON
"SFW_PACKAGE~" ("SWITCH_ID", "VERSION",
"DEVCLASS") PCTFREE 10 INITRANS 002 TABLESPACE PSAPES740I NOCOMPRESS
STORAGE (INITIAL 0000000072 K NEXT 0000001024 K MINEXTENTS 0000000001 MAXEXTENTS
UNLIMITED PCTINCREASE 0000 FREELISTS 001) 3 ETGCLN DELETE FROM DDSTORAGE WHERE
DBSYSABBR = 'ORA' AND TABNAME = 'SFW_PACKAGE~' AND INDEXNAME = '0' 3 ETGCLN
insert /*+ APPEND */ into "SFW_PACKAGE~" ( "SWITCH_ID",
"VERSION", "DEVCLASS", "ENHNAME" ) select
"SWITCH_ID", "VERSION", "DEVCLASS",
"ENHNAME" from "SFW_PACKAGE" 3 ETGCLN Number of original
rows: 1952. Number of copied rows: 1952. 3 ETGCLN CREATE UNIQUE INDEX
"SFW_PACKAGE~P" ON "SFW_PACKAGE~" ("DEVCLASS",
"VERSION") PCTFREE 10 INITRANS 002 TABLESPACE PSAPES700I STORAGE
(INITIAL 0000000064 K NEXT 0000001024 K MINEXTENTS 0000000001 MAXEXTENTS
UNLIMITED PCTINCREASE 0000 FREELISTS 001) 1EETGCLN ORA-00959: tablespace
'PSAPES700I' does not exist 1EETGCLN SFW_PACKAGE 1EETGCLN Error when cloning
table indexes

--------------------------------------------------------------------------

After looking for quite some time I found no solution for this so that I contacted the support team and they helped me to resolve this.

Hint (check this first):

While I was on my search I didn't find SAP Note 666061 - Section 15.

This might help one of you in the future.

Solution:

1. Call transaction SE16
   1. Table DDSTORAGE
   2. Tabname = SFW_PACKAGE, text = PSAPES7*
      
      This showed me that there is some old data pointing to a table that does not exist anymore
2. Call transaction SE14
   1. Edit table SFW_PACKAGE
   2. Click on "Storage Parameter"
   3. Click on "For new creation"
   4. Edit the entry pointing to the old table and change it to the correct/new table
   5. Save and exit.

I'll be thankful for any kind of feedback.

Kind regards

Niklas