Re: EMPY BLOCK on table
From: Scott Watson <swatson_at_datachest.com>
Date: Fri, 18 May 2001 12:15:56 -0400
Message-ID: <BQbN6.20818$ee1.1397207_at_news20.bellglobal.com>
Date: Fri, 18 May 2001 12:15:56 -0400
Message-ID: <BQbN6.20818$ee1.1397207_at_news20.bellglobal.com>
look up the command alter table deallocate unused.
HTH
Scott.
"Gritto" <agrittini_at_yahoo.com> wrote in message
news:3b052a8e$0$17707_at_ams2eusosrv31.ams.ops.eu.uu.net...
> Does anyone know how to release the empty_block allocated for a table?
> Querying a table from all_tables tells you the number of the empty blocks
> allocated.
> Is there a command that deallocate this blocks without exporting and
> reimporting the table? or deleting and recreating?
> Any help will be appreciated.
> Thank you
>
> Andrea Grittini
> Computer Design
> www.cdesign.it
> mailto:andrea.grittini_at_cdesign.it
>
>
>
Received on Fri May 18 2001 - 18:15:56 CEST