brspace -f tbreorg -t "*" -a cleanup command

[Former Member]

Hi All

we have  around 124GB for stuck #$ table after online reorg fail,can you please update me how safe is command brspace -f tbreorg -t "*" -a cleanup  command in running system?, and its impact on EDI40 table?

Thanks

Dinesh

[stefan_koehler]

Hi Dinesh,

> can you please update me how safe is command brspace -f tbreorg -t "*" -a cleanup  command in running system?, and its impact on EDI40 table?

It is safe and has no impact on the original table. The database objects with the suffix "#$" are related to the interim (table) object and it is cleaned up with PL/SQL procedure DBMS_REDEFINITION.ABORT_REDEF_TABLE (and following drop).

http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_redefi.htm#i998327

Regards

Stefan

[AtulKumarJain]

Hi Dinesh,

As per sap note 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

PLease check note for more info.

BR

Aj