on 12-19-2013 3:24 AM
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#$.
Hi
Please try to search 1st, it can avoid to have the same question asked many times
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.