Skip to Content
Feb 08, 2020 at 07:16 AM

Space not reclaimed after table drop



Have HDB database (1.2TB in size) and one table with 902GB in size according to M_TABLE_PERSISTENCE_STATISTICS. This is MES_DB_AGGREGATE from SOLMAN database. We restore this database on test sandbox and try to DROP TABLE and next ALTER SYSTEM RECLAIM DATAVOLUME 120 DEFRAGMENT, but datavolume size not changed.

Also, what is strange if I make a copy of this table (CTAS) , then it takes up the size of 541 megabytes only.

What else can be done to reduce the size of the datavolume and /hana/data filesystem

Best regards,