You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by bruehlicke <br...@gmail.com> on 2009/12/02 03:43:01 UTC

Reclaim deleted tablespace ?

I may not have read all docs, but after I run a cascading delete on
200 megs of row data and I check the folder size on disk nothing has
changed ?

Is there any specific command to be run to claim the space deleted ?

Thanx
B-)

Re: Reclaim deleted tablespace ?

Posted by bruehlicke <br...@gmail.com>.

Excellent !  Any command which will do it on a DB base an not just
table by table

B-)

On Tue, Dec 1, 2009 at 8:52 PM, Bryan Pendleton
<bp...@amberpoint.com> wrote:
>> Is there any specific command to be run to claim the space deleted ?
>
> Not a command, but a built-in system procedure:
> http://db.apache.org/derby/docs/10.5/ref/rrefaltertablecompress.html
>
> thanks,
>
> bryan
>
>

Re: Reclaim deleted tablespace ?

Posted by Bryan Pendleton <bp...@amberpoint.com>.

> Is there any specific command to be run to claim the space deleted ?

Not a command, but a built-in system procedure:
http://db.apache.org/derby/docs/10.5/ref/rrefaltertablecompress.html

thanks,

bryan