How to do Reorganization by table ?

[Former Member]

Hi, all experts,

Now my company need to do Reorganization, who have the experience about it ?

Could you give me the assumably steps ?

Thanks in advance ,

Best wishes,

Michael

[Former Member · Accepted solution]

See also the "BRSPACE - Top 10 Pitfalls and Problems" presentation available on SDN:

http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70cf010d-0b01-2d10-86a2-a0636c39a...

[Former Member]

ok , thanks for all reply !

[Former Member]

Hi,

what version of of SAP DB ?

Mark

[former_member524429]

Hi,

You can use BRSPACE functionality of BR*Tools/SAPDBA. Under Segment Management -> Reorganize Tables.

you can Specify the Table Name, Table space Name, relative Table Name (e.g. VB*).

If you are having Locally Managed Table space, then reorganization of Table or Table spaces are less required.

Refer these following links to get more info with detailed screen shots.

[Table Reorganization Screen shots|http://sapbasis.wordpress.com/2008/07/16/table-reorganization-using-brspace-via-temporary-tablespace/]

[Simple Table Reorganization for SAP R/3 using BRSPACE|http://www.saptechies.com/simple-table-reorganization-for-sap-r3-using-brspace/]

[Note 541538 - FAQ: Reorganization|https://service.sap.com/sap/support/notes/541538]

Regards

Bhavik G. Shroff

[anindya_bose]

Hi Michael

Please go through the links below

Link: [Link1|;

Link: [Link2|;

Please let us know if you have any question.

Best Regards

Anindya