Solution : https://service.sap.com/sap/support/notes/35952 (SAP Service marketplace login required)
Summary :
When a client or a substantial amount of data is deleted, the database space does not immediately reduce due to the nature of certain databases such as Oracle and Informix. This absence of size reduction results from tables maintaining their size, filling cleared sections with new data over time. Immediate space recovery requires database reorganization. This is advised either when the deleted data volume won't be replaced soon, or if small non-reusable gaps accumulate, leading to inefficient space usage. Utilizing transaction DB02 can help in managing these reorganization tasks efficiently.
Key words :
additional key words tablespace database space reorganization db02, space occupied, cleared space, reorganization, large quantity, prerequisites data, deleting data, cleared areas, normal behavior, existing clients
Related Notes :
| 70643 | CC-TOPIC: Client Deletion (SCC5) |
| 41300 | Table DBTABPRT is very large |
| 36781 | Table APQD is very large |
| 7462 | Client delete and copy: space not reused |