db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <knut.hat...@oracle.com>
Subject Re: Reclaiming space from Derby
Date Wed, 08 Sep 2010 11:19:09 GMT
Paul Taylor <paul_t100@fastmail.fm> writes:

> 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,

The database files won't shrink unless you compress the tables.

http://db.apache.org/derby/docs/10.6/ref/rrefaltertablecompress.html
http://db.apache.org/derby/docs/10.6/ref/rrefproceduresinplacecompress.html

Hope this helps,

-- 
Knut Anders

Mime
View raw message