cancel
Showing results for 
Search instead for 
Did you mean: 

Table reorganization using brtools

former_member199632
Participant
0 Kudos

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]

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

This message was moderated.

former_member182034
Active Contributor
0 Kudos

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,

sunny_pahuja2
Active Contributor
0 Kudos

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