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
