db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel Noll <dan...@nuix.com>
Subject Re: How delete rows in table with free disk space?
Date Tue, 03 Jul 2007 23:20:17 GMT
On Tuesday 03 July 2007 00:08:43 Ekrame Ayari wrote:
> Hi
>
> I wish to remove table rows to allow user decrease space disk.
>
> I try to delete table rows for free disk space with this code :
>
> "Connect connect =
> DriverManager.getConnection("jdbc:derby:GenoCensusMin2"); Statement stat =
> connect.createStatement();
> stat.executeUpdate("DELETE FROM Project WHERE id="+idProjet);"
>
> But disk space size of my system directory is the same before and after
> the deletion.
>
> Can you help me?

Have you tried using SYSCS_UTIL.SYSCS_COMPRESS_TABLE ?

Daniel


-- 
Daniel Noll
Nuix Pty Ltd
Suite 79, 89 Jones St, Ultimo NSW 2007, Australia    Ph: +61 2 9280 0699
Web: http://nuix.com/                               Fax: +61 2 9212 6902

Mime
View raw message