MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE ORA-00959: tablespace does not exist
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 <= 8) 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:
- Call transaction SE16
- Table DDSTORAGE
- Tabname = SFW_PACKAGE, text = PSAPES7*
This showed me that there is some old data pointing to a table that does not exist anymore
- Call transaction SE14
- Edit table SFW_PACKAGE
- Click on “Storage Parameter”
- Click on “For new creation”
- Edit the entry pointing to the old table and change it to the correct/new table
- Save and exit.
I’ll be thankful for any kind of feedback.
Kind regards
Niklas
Hello Niklas,
Thanks for sharing this. I solved my issue with this doc.
Hi Mahendra,
thanks for letting me know. I'm glad I could help.
Regards,
Niklas
Perfect !
Exactly what we needed to solve our Problem.
However: In addition to the steps mentioned by you, we had to delete and recreate the tables using SE14 after adjusting the Parameters.
Best Regards,
Thomas