Problem during database load

[chakrishroff]

Hi Guys,
I am trying to install SAP 4.7 EX set 2. My installation was interrupted due to power failure. I continued again with the old installation. During the phase of R3 load I am getting error below error. I can manually drop these objects from database level to resolve this. But the objects are over 4000. is there any other way to fix this problem. Please advise. Thanks..
(CREATE TABLE "/SCMB/DF_DOC_VAL" ( "CLIENT" VARCHAR2(3) DEFAULT '000' NOT NULL , "GUID" RAW(16) NOT NULL , "CHARACTERISTIC" CLOB ) TABLESPACE PSAPKRD STORAGE (INITIAL 65536 NEXT 0000020480K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )
DbSlExecute: rc = 102
(SQL error 955)
error message returned by DbSl:
ORA-00955: name is already used by an existing object
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "/SCMB/DF_DOC_VAL~0" ON "/SCMB/DF_DOC_VAL" ( "CLIENT", "GUID" ) TABLESPACE PSAPKRD STORAGE (INITIAL 0 NEXT 0000005120K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )
DbSlExecute: rc = 102
(SQL error 955)
error message returned by DbSl:
ORA-00955: name is already used by an existing object
(DB) ERROR: DDL statement failed
(CREATE TABLE "/SCMB/DF_DQTY" ( "CLIENT" VARCHAR2(3) DEFAULT '000' NOT NULL , "LINK_ID" RAW(16) NOT NULL , "QTY" NUMBER(31,14) DEFAULT 0 NOT NULL , "UOM" VARCHAR2(3) DEFAULT ' ' NOT NULL ) TABLESPACE PSAPKRD STORAGE (INITIAL 65536 NEXT 0000000640K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )
DbSlExecute: rc = 102
(SQL error 955)
error message returned by DbSl:
ORA-00955: name is already used by an existing object
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "/SCMB/DF_DQTY~0" ON "/SCMB/DF_DQTY" ( "CLIENT", "LINK_ID" ) TABLESPACE PSAPKRD STORAGE (INITIAL 0 NEXT 0000000160K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )
DbSlExecute: rc = 102
(SQL error 955)
error message returned by DbSl:
ORA-00955: name is already used by an existing object

[hussaini]

Hi,

go to operating system level to the datafiles in oracle/sid folder
there you can delete the datafiles and start the database instance once again.

bcoz if there is any interruption while the r3load phase is running and the installation got stopped then it would corrupt the data file for which it was writing the data so delete all the datafiles and start the database instance installation again.

[chakrishroff]

Thanks Hussaini, But this was not a data corruption. Anyways I have figured out what the problem is after some research and was able to install database inst with out reinstallation.