Does database size reduse while deleting a client with

[Former Member]

Hi All,

I am going to delete a client (having more than 16000 tables) with t-code scc5.

Please someone tell me that, The size of database will reduce or not ?

According to me: When ever we delete any object form database, Size of database will reduce.

Thanks & Regards

[boobboo · Accepted solution]

When you delete items from a database, the space is not freed up as it would be in the case of a file system.

Bcause the data is written in 'pages' you need to re-organise the data so all the pages are in a continguous list.

So no you cannot reclaim the space without doing a database re-organisation.

Chris

[Former Member · Accepted solution]

Hi Chris Kernaghan,

Thanks for the solution...

Now I get free space in my database.

Thanks for the help.

[Former Member]

Hi,

Data is deleted from tables when deleting a client. But to get the space immediately after client deletion,you may have to reorganize the database.

Please check the Note 35952 for details on space after client deletion.

If your DB is Oracle then you can also check Note 7462 for more details on reusing the released space in a database block.