Kbase P3295: How to reduce the database size after deleting records
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/3/2009 |
|
Status: Verified
GOAL:
How to reduce the database size after deleting records
FACT(s) (Environment):
Progress/OpenEdge Product Family
All Supported Operating Systems
FIX:
Although you deleted records in a database, the database size will not change.
This is because the deleted records are simply marked as deleted, they are not actually removed. The blocks will be re-used before the database physically grows again.
If you want to reduce the database size by removing the white spaces left by deletions, you have to perform a Dump and Load, either binary or via the Data Dictionary/Administration.