db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rajesh Kartha <kar...@Source-Zone.Org>
Subject Re: BLOB suppression : can't recover disk space
Date Thu, 01 Sep 2005 14:37:15 GMT
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



Mime
View raw message