on 12-05-2011 8:37 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.