db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kristian Waagan <kristian.waa...@oracle.com>
Subject Re: Reclaiming space from Derby
Date Wed, 08 Sep 2010 11:02:38 GMT
  On 08.09.10 12:50, Paul Taylor wrote:
> HI, I use derby in embedded mode, I let the user specify a maxmium 
> size for the derby database files, my program monitors this and if it 
> goes over the size I use SQL to delete records that are no longer 
> necessary in the hope of shrinking the database files size, but it 
> doesn't, how can I force Derby to shrink back down ?

Hi Paul,

You have to run the compress system procedures. See these links for more 
information:
http://db.apache.org/derby/docs/dev/ref/ref-single.html#rrefaltertablecompress
http://db.apache.org/derby/docs/dev/ref/ref-single.html#rrefproceduresinplacecompress


Hope this helps,
-- 
Kristian

>
> thanks Paul


Mime
View raw message