Grégoire Dubois wrote:
Hi all,
I inserted a 700Mo file into a blob (using embedded jdbc driver).
Then I use the command DELETE to delete the blob from the database. The
blob is well removed. But the disk space isn't recovered.
Is there a command that permits the recovery of disk space when using
blobs?
Thank you very much.
Grégoire
Hi Grégoire,
Here is some info about reclaiming unused space using
SYSCS_UTIL.SYSCS_COMPRESS_TABLE
http://db.apache.org/derby/docs/10.1/adminguide/cadminspace21579.html
This is from the Derby documentation.
Regards,
Rajesh
