Skip to Content
0
Former Member
Dec 05, 2011 at 08:37 AM

ORA-00955: name is already used by an existing object

902 Views

Dear Experts,

We are haveing ECC 6.0 System and Oracle10g as DB.We started Online db reorg using Brtools for table BSIS and it ran for log time.In the meanwhile next day users started complaning so my colleague killed the Reorg Process.

So now i tried to reorg the same table but it is shwoing that a temporary table is already created and Reorg can not be Proceeded.

BR0301E SQL error -955 at location tab_onl_reorg-17, SQL statement:
'CREATE TABLE "SAPSR3"."BSIS#$"
   (    "MANDT" VARCHAR2(9) DEFAULT '000' NOT NULL ENABLE,
        "BUKRS" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
        "HKONT" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE,
        "AUGDT" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE,
        "AUGBL" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE,
        "ZUONR" VARCHAR2(54) DEFAULT ' ' NOT NULL ENABLE,
        "GJAHR" VARCHAR2(12) DEFAULT '0000' NOT NULL ENABLE,
        "BELNR" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE,
        "BUZEI" VARCHAR2(9) DEFAULT '000' NOT NULL ENABLE,
        "BUDAT" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE,
        "BLDAT" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE,
        "WAERS" VARCHAR2(15) DEFAULT ' ' NOT NULL ENABLE,
        "XBLNR" VARCHAR2(48) DEFAULT ' ' NOT NULL ENABLE,
        "BLART" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
        "MONAT" VARCHAR2(6) DEFAULT '00' NOT NULL ENABLE,
        "BSCHL" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
        "SHKZG" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
        "GSBER" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
        "MWSKZ" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
        "FKONT" VARCHAR2(9) DEFAULT '000' NOT NULL ENABLE,
        "DMBTR" NUMBER(13,2) DEFAULT 0 NOT NULL ENABLE,
        "WRBTR" NUMBER(13,2) DEFAULT 0 NOT NULL ENABLE,
        "MWSTS" NUMBER(13,2) DEFAULT 0 NOT NULL ENABLE,
        "WMWST" NUMBER(13,2) DEFAULT 0 NOT NULL ENABLE,
        "SGTXT" VARCHAR2(150) DEFAULT ' ' NOT NULL ENABLE,
        "PROJN" VARCHAR2(48) DEFAULT ' ' NOT NULL ENABLE,
        "AUFNR" VARCHAR2(36) DEFAULT ' ' NOT NULL ENABLE,
        "WERKS" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
        "KOSTL" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE,
        "ZFBDT" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE,
        "XOPVW" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
        "VALUT" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE,
        "BSTAT" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
        "BDIFF" NUMBER(13,2) DEFAULT 0 NOT NULL ENABLE,
        "BDIF2" NUMBER(13,2) DEFAULT 0 NOT NULL ENABLE,
        "VBUND" VARCHAR2(18) DEFAULT ' ' NOT NULL ENABLE,
        "PSWSL" VARCHAR2(15) DEFAULT ' ' NOT NULL ENABLE,
        "WVERW" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
        "DMBE2" NUMBER(13,2) DEFAULT 0 NOT NULL ENABLE,
        "DMBE3" NUMBER(13,2) DEFAULT 0 NOT NULL ENABLE,
        "MWST2" NUMBER(13,2) DEFAULT 0 NOT NULL ENABLE,
        "MWST3" NUMBER(13,2) DEFAULT 0 NOT NULL ENABLE,
        "BDIF3" NUMBER(13,2) DEFAULT 0 NOT NULL ENABLE,
        "RDIF3" NUMBER(13,2) DEFAULT 0 NOT NULL ENABLE,
        "XRAGL" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
        "PROJK" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE,
        "PRCTR" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE,
        "XSTOV" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
        "XARCH" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
        "PSWBT" NUMBER(13,2) DEFAULT 0 NOT NULL ENABLE,
        "XNEGP" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
        "RFZEI" VARCHAR2(9) DEFAULT '000' NOT NULL ENABLE,
        "CCBTC" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE,
        "XREF3" VARCHAR2(60) DEFAULT ' ' NOT NULL ENABLE,
        "BUPLA" VARCHAR2(12) DEFAULT ' ' NOT NULL ENABLE,
        "PPDIFF" NUMBER(13,2) DEFAULT 0 NOT NULL ENABLE,
        "PPDIF2" NUMBER(13,2) DEFAULT 0 NOT NULL ENABLE,
        "PPDIF3" NUMBER(13,2) DEFAULT 0 NOT NULL ENABLE,
        "BEWAR" VARCHAR2(9) DEFAULT ' ' NOT NULL ENABLE,
        "IMKEY" VARCHAR2(24) DEFAULT ' ' NOT NULL ENABLE,
        "DABRZ" VARCHAR2(24) DEFAULT '00000000' NOT NULL ENABLE,
        "INTRENO" VARCHAR2(39) DEFAULT ' ' NOT NULL ENABLE,
        "GRANT_NBR" VARCHAR2(60) DEFAULT ' ' NOT NULL ENABLE,
        "FKBER" VARCHAR2(48) DEFAULT ' ' NOT NULL ENABLE,
        "FIPOS" VARCHAR2(42) DEFAULT ' ' NOT NULL ENABLE,
        "FISTL" VARCHAR2(48) DEFAULT ' ' NOT NULL ENABLE,
        "GEBER" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE,
        "PPRCT" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE,
        "BUZID" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLE,
        "AUGGJ" VARCHAR2(12) DEFAULT '0000' NOT NULL ENABLE,
        "UZAWE" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
        "SEGMENT" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE,
        "PSEGMENT" VARCHAR2(30) DEFAULT ' ' NOT NULL ENABLE,
        "FIPEX" VARCHAR2(72) DEFAULT ' ' NOT NULL ENABLE,
        "PRODPER" VARCHAR2(18) DEFAULT ' ' NOT NULL ENABLE,
        "QSSKZ" VARCHAR2(6) DEFAULT ' ' NOT NULL ENABLE,
        "PROPMANO" VARCHAR2(39) DEFAULT ' ' NOT NULL ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 16384 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "PSAPSR3" '
ORA-00955: name is already used by an existing object
BR0280I BRSPACE time stamp: 2011-12-04 22.01.05
BR1106E Reorganization of table SAPSR3.BSIS failed

So my question is shall i drop the old object and proceed for Table reorg again.

Will there be any dataloss ??

Regards

Kuldeep Singh