How get rid of empty blocks ?
345144Mar 17 2003 — edited Mar 18 2003In order to reclaim space in my schema, I tried to get rid of empty blocks for tables that have 0 rows by issuing
TRUNCATE TABLE TABLE_NAME DROP STORAGE;
Than, in order to refresh user_tables, I ran ANALYZE TABLE TABLE_NAME COMPUTE STATISTICS.
When I query user_tables for empty_blocks, I still have them all there, they have not gone. Does not Truncate work for this ? Or am I doing something wrong ? What should I do in order to reclaim space ?
Thanks