Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
EMPY BLOCK on table
0 views
Skip to first unread message
Gritto
May 18, 2001, 9:58:13 AM5/18/01
to
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
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....@cdesign.it
Scott Watson
May 18, 2001, 12:15:56 PM5/18/01
to
look up the command alter table deallocate unused.
HTH
Scott.
"Gritto" <agri...@yahoo.com> wrote in message
news:3b052a8e$0$17...@ams2eusosrv31.ams.ops.eu.uu.net...
0 new messages