on 07-27-2010 3:00 PM
Hi i have to update our spam/saint.
We are at level 7.00/0026
I have extract the KD70037.SAR file
When i done the import i have theses errors :
15:03:45: Retcode 1: error in DDL statement for CLNT_CVRS2 - repeat
Error 959-ORA-00959: tablespace 'PSAPSR3' does not exist when executing ADD-FIELD of
Error CLNT_CVRS2 when executing ADD-FIELD of
(dummy, do not translate)
No DDL commands found for activation of CLNT_CVRS2
15:03:57: Retcode 1: error in DDL statement for OCSCCOMPAT - repeat
Error 959-ORA-00959: tablespace 'PSAPSR3' does not exist when executing ADD-FIELD of
Error OCSCCOMPAT when executing ADD-FIELD of
(dummy, do not translate)
No DDL commands found for activation of OCSCCOMPAT
15:04:09: Retcode 1: error in DDL statement for OCSSPCOMPR - repeat
Error 959-ORA-00959: tablespace 'PSAPSR3' does not exist when executing ADD-FIELD of
Error OCSSPCOMPR when executing ADD-FIELD of
(dummy, do not translate)
No DDL commands found for activation of OCSSPCOMPR
(dummy, do not translate)
(dummy, do not translate)
(dummy, do not translate)
(dummy, do not translate)
(dummy, do not translate)
(dummy, do not translate)
(dummy, do not translate)
(dummy, do not translate)
(dummy, do not translate)
15:04:22: Retcode 1: error in DDL statement for PATRTCONF - repeat
Error 959-ORA-00959: tablespace 'PSAPSR3' does not exist when executing ADD-FIELD of
Error PATRTCONF when executing ADD-FIELD of
(dummy, do not translate)
No DDL commands found for activation of PATRTCONF
15:04:34: Retcode 1: error in DDL statement for PATRTPHASE - repeat
Error 959-ORA-00959: tablespace 'PSAPSR3' does not exist when executing ADD-FIELD of
Error PATRTPHASE when executing ADD-FIELD of
(dummy, do not translate)
No DDL commands found for activation of PATRTPHASE
15:04:46: Retcode 1: error in DDL statement for PATRTVERS - repeat
Error 959-ORA-00959: tablespace 'PSAPSR3' does not exist when executing ADD-FIELD of
Error PATRTVERS when executing ADD-FIELD of
(dummy, do not translate)
Someone know how to solve the problem?
For information the tablespace PSAPSR3 not exist!! I don't kno why the program search this one....
Regards.
Edited by: BABY Fabrice on Jul 27, 2010 4:02 PM
> Error 959-ORA-00959: tablespace 'PSAPSR3' does not exist when executing ADD-FIELD of
This is a default tablespace if your SID is SR3.
Did you modify any of those parameter during the installation of the system?
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In fact the system where i want to update Spam is a copy from an other system.
The source system was upgraded to 701 few weeks ago.
But i have look in the 701 system ( the old source system upgraded ) and effectively there is PSAPSR3 tablespace witch is not the case in the target client...
I supose after the copy someone made change in the tablespace name.
I will investigate in this direction.
Regards.
In in the system where i want to update SPAM there are theses tablespace :
NEWTBSSAPSR3
NEWTBSSAPSR3700
PSAPSR3DB
PSAPSR3USR
PSAPTEMP2010
PSAPUNDO
SYSAUX
SYSTEM
Is there a way to know witch tablespace is active (or default) like the PSAPSR3 ( i supose this is the NEWTBSSAPSR3700 ) how to be sure.
Regards.
Edited by: BABY Fabrice on Jul 27, 2010 4:59 PM
Edited by: BABY Fabrice on Jul 27, 2010 5:00 PM
Edited by: BABY Fabrice on Jul 27, 2010 5:09 PM
> Is there a way to know witch tablespace is active (or default) like the PSAPSR3 ( i supose this is the NEWTBSSAPSR3700 ) how to be sure.
How did you do the system copy? That kind of naming is non-standard and doesn't work with SAP systems - if you don't change all the technical settings in all tables.
Markus
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.