Kbase P7289: Will deleteing records reclaim disk size?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/19/2009 |
|
Status: Verified
GOAL:
Does deleting records from the database reclaim disk space?
GOAL:
Why does my database size not shrink after i delete a bunch of records?
FACT(s) (Environment):
UNIX
Windows
Progress/OpenEdge Versions
FIX:
No it does not. Fixed length extents are created at the defined size. When the database grows into the variable extent and the system is running out of disk space, deleting records will not reclaim disk space. It will, however, free up existing data blocks to be reused.