Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Dec 05, 2011 at 08:55 AM

    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

    Add comment
    10|10000 characters needed characters exceeded