Reorganization

Client Deleted. Space still filled up in Database Note: 35952

Data is deleted from tables when deleting a client. Some databases (for example Oracle and Informix, but not Adabas D) have the attribute that the space occupied by tables is not changed when deleting data. The cleared areas within the tables can however be filled with new data.

Soln:

This is the normal behavior of the database and not an error. If new data is stored (creation of a new client, adding further data to already existing clients), the space of the deleted client is reused.

If you want to immediately recover the cleared space, you must reorganize the database (or at least parts of it). There are two reasons for performing reorganization:

 A "large" client with a large amount of data was deleted and this amount of data will not be added to the system in the foreseeable future.

 After deleting the client, a lot of small areas (individual records) can have been deleted in the database. These small gaps are not completely recycled. Particularly after the repeated deletion of clients, the space in the database can be utilized inefficiently.

Confused? Feel free to ask

Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk