Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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

Former Member
Former Member replied

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

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question