Skip to Content
author's profile photo Former Member
Former Member

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

Posted on Sep 05, 2013 at 10:41 PM 674 Views

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

pastedImage_1.png (10.2 kB)
Oracle Database
Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Stefan Koehler
    Stefan Koehler
    Posted on Sep 06, 2013 at 08:07 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Atul Kumar Jain
    Atul Kumar Jain
    Posted on Sep 06, 2013 at 03:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded