cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Check note [541538 - FAQ: Reorganization|https://service.sap.com/sap/support/notes/541538]

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

If this error occurs when you are creating the target table (with the suffix "#$"), it is probably because a preceding reorganization was canceled without the target table being deleted. In this situation, perform a cleanup:

brspace -f tbreorg -t "*" -a cleanup

Also consider to open a OSS message if you are not sure about it. I had to use the cleanup procedure a few times and it worked correctly so far.

Cheers Michael

Former Member
0 Kudos

Thanks Michael

Answers (0)