How to check tables for Reorg

[Former Member]

Hi Experts,

Is there any way(Tcode etc) to determine which database tables need to be re-orged at the SAP level.

Basically, we have access only to SAP and need to determine which tables need to be re-orged.

Thanks and Regards,

Ravi

[marc_saulnier]

Hi try this transaction,

db02 => Space => Tables and Indexes and and select Option "Flagged Tables" to search all tables who need a Reorg

regards

[Former Member]

Hi Marc,

There is no option in DB02 for 'Flagged Tables'.

Can you describe where it is.

Our structure is DB02->Space. There is no option for Tables and Indexes as you had specified.

Thanks,

Ravi

[marc_saulnier]

In the structure, expand space and double click on Tables and Indexes in the navigation frame. After that, in the filter selection you should have a checkmark to choose "Flagged table" to view only table where a reorg is require.

Please check the link below :

http://help.sap.com/saphelp_bw32/helpdata/en/60/42c552e00411d18d900000e816c2ff/content.htm

If the optionm is not there, can you tell me what is your sap version ?

regards