Re: does delete records free up dbspace?
Deleting records does not free up the dbspace; You can re-claim back the
space by either :
- Alter index to cluster
- load the data out and re-load it back (using dbexport/dbimport or
onunload/onload)
Regards
To: "informix-list@iiug.org" <informix-list@iiug.org>
cc: (bcc: Fauziah Ayob/MESINIAGA)
From: "Yan Zhu" <yan.zhu@infinity-insurance.com> @ MBEXT
Date: 10/02/99 12:34:09 AM GMT
Subject: does delete records free up dbspace?
hi all:
I deleted a bunch of records from my database, around 1/3, but when
I do a onstat -d, the dbspace usage remain the same, how could that be?
if that's the case, how could I tell how full my database is at a given
time?
thanks a lot. btw, i am running 7.22 with solaris 2.6
yan