reorg

[Former Member]

Hi all,

previously we reorg the table FAGLFLEXA but some cause we cancel the reorg.

Again we start the re-org then show error.

BR0280I BRSPACE time stamp: 2013-12-19 07.43.53

BR1101I Starting 'online' table reorganization...

BR0280I BRSPACE time stamp: 2013-12-19 07.43.53

BR1124I Starting 'online' reorganization of table SAPSR3.FAGLFLEXA

BR0280I BRSPACE time stamp: 2013-12-19 07.44.01

BR0301E SQL error -955 at location tab_onl_reorg-19, SQL stateme

'CREATE TABLE "SAPSR3"."FAGLFLEXA#$"

   (#"RCLNT" VARCHAR2(3) DEFAULT '000' NOT NULL ENABLE,

#"RYEAR" VARCHAR2(4) DEFAULT '0000' NOT NULL ENABLE,

#"DOCNR" VARCHAR2(10) DEFAULT ' ' NOT NULL ENABLE,

#"RLDNR" VARCHAR2(2) DEFAULT ' ' NOT NULL ENABLE,

#"RBUKRS" VARCHAR2(4) DEFAULT ' ' NOT NULL ENABLE,

:

:

ora-00955 name is already used by an existing object

Please help how i remove the object SAPSR3"."FAGLFLEXA#$.

[ACE-SAP · Accepted solution]

Hi

Please try to search 1st, it can avoid to have the same question asked many times

541538 - FAQ: Reorganization

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

Regards

[Reagan]

Hello

You may read this SAP note

541538 - FAQ: Reorganization

Regards

RB