on 03-12-2015 9:26 AM
Hallo.
I use SWPM 1.0 to migrate Solution Manager 7.1 , from :
windows 2003 oracle 11.2.0.3
to
windows 2008 R2 oracle 11.2.0.4
I executed SMIGR_CREATE_DDL on the source system, I executed the export from SWPM->Solman 7.1 SR1 - >...
After I import in the target but I obtain for many indexes I have the error:
ORA-00955: name is already used by an existing object
I think that it could be a problem on the scripts generated by SMIGR_CREATE_DDL
It seems a problem related to some IOTs table script
For example, I have the error:
(DB) ERROR: DDL statement failed
( CREATE UNIQUE INDEX "TPFYDOC~0" ON "TPFYDOC" ("OBJ_NAME", "LANGU", "SEQNO") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 COMPRESS 2 STORAGE (INITIAL 0000000064 K NEXT 0000001024 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001) )
DbSlExecute: rc = 102
(SQL error 955)
error message returned by DbSl:
ORA-00955: name is already used by an existing object
(DB) INFO: disconnected from DB
In the attachment SDOCU.SQL there is the one of the .SQL files generated by SMIGR_CREATE_DDL .
Note that table TPFYDOC was converted to IOT as I verified by:
SQL> SELECT TABLE_NAME, INDEX_NAME FROM DBA_INDEXES WHERE INDEX_TYPE = 'IOT - TOP';
So the errors, seem related to the wrong interpretation of IOT by the SMIGR_CREATE_DDL report.
Could you help me?
Thanks a lot
Mario
Hallo.
I found oss note:
2129884 - Error during homogeneous migration of IOT table
but it isn't releaased for my support packages level...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Mario,
If you have your source system still avilable try to replace the .LST by re-executing the smigr_create_DDL.
Also you can replace the DDLORA.TPL under \export\abap\DB\ORA(The location may differ in your case) file from the dump with the one from the SWPM sap inst log directory. and give a re-try.
Let us know if this help.
Regards,
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hallo.
I skipped the error changing the .TSK files and successfullty import .
But, I think that there is a problem on the report SMIGR_CREATE_DDL.when it manages IOT object.
Do you think that I had to open an Oss message to the SAP Support?
Thanks a lot.
Mario
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mario
Could you check this SAP KBA for error message "ORA-00955: name is already used by an existing object"
1844436 - ORA-00955: name is already used by an existing object
BR
SS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mario
I think you have to delete the index and retry the system copy refer the SAP KBA
2092401 - ORA-09555: name is already used by an existing object during EHP upgrade
BR
SS
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.