purgaing a data in sap database for space

[Former Member]

hi gurus

i have problem in space management in sap database, i cant increase physical space in my server so i purge a data from the database, in sap i show that some table space has found free fragment also but how i use or remove fragment threw sap (TCODE) so please help me i wait your replay thanlks because this is development database of sap so please replay me

thanks

nainesh suthar

[anindya_bose]

HI

You can check SAP Note 706478 - Preventing Basis tables from increasing considerably.

After deletion of some table entries , you can reoprganize the database to gain some ( may be lots of ) space.

Few tables ( which does not contain LONG RAW field) you can reorganize online from brtool and for some tables you will need simple export /import method.

For reorganization you can have a look at the link below and get back to us if you face any problem