Problem during database load
Posted:
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
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