Table Reorganization for Table/index name BALDAT

[Former Member]

Hello,

As per EWA report :Implement SAP Note 195157 for Table Reorganization .

But this note is not applicable to my system.

My system is on SAP SOLUTION MANAGER 7.1.Can someone help me on this ,what is the note i have to implement to get rid of this recommendation.

[Reagan]

I would say that the SAP note 195157 - Application log: Deletion of logs is generic.

You should first delete the application logs as suggested in the note.

If the system is running on an Oracle database then use BR*Tools to do a table reorganization.

Regards

RB

[Former Member]

Hello,Do we have any SAP note to follow above procedure.

Regards

CC

[former_member188883]

Hi Chandra,

You may follow below process

1) Clean up old application logs using SLG2 transaction

2)  Follow the steps in Wiki below to perform table reorganization

http://wiki.scn.sap.com/wiki/display/Basis/Table+reorganization+on+a+table+space+in+Oracle

Hope this helps.

Regards,

Deepak Kori

[Reagan]

You can either call Tx SLG2 or call Tx SE38 and run the report SBAL_DELETE to delete the logs.

Regards

RB