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 

Hope this helps,

> thanks Paul

View raw message