Skip to Content

Table reorganization using brtools

Hi,

I have done sample table reorganizations in a test system using brtools.

big tables such as BSEG,VBAK,LIKP ..

I wants to know what will happens to a  table reorganization process. ?

Whats the purpose of table reorganization.

Is it possible to check whether the reorganization process is successful or not.

(for example by checking the space acquired or any other way)

How to identify in production environment , whether a specific table needs reorganization or not.

kindly clarify me

regards,

zerandib

[Please research your question more completely, and if necessary, post again] [MODERATOR]

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Mar 11, 2013 at 05:03 AM

    Hi,

    Reorganization is required to release space and you can also reduce number of extents from db if you delete some data from table. You can check logs of reorganization in sapreorg folder.

    For more information, check below link:

    https://help.sap.com/saphelp_nwpi71/helpdata/en/46/b869864e771516e10000000a114a6b/content.htm

    Thanks

    Sunny

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 11, 2013 at 05:08 AM

    Dear Zerandib,

    please check the links against your queries it might be helpful.

    what will happens to a  table reorganization process. ?

    Whats the purpose of table reorganization

    .

    Reorganization

    Is it possible to check whether the reorganization process is successful or not.

    (for example by checking the space acquired or any other way)

    table reorg online using brspace

    How to identify in production environment , whether a specific table needs reorganization or not

    Note 22941 - Reorganization of tables and dbspaces!

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 11, 2013 at 05:08 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded