Re: How to be freed EXTENTED space?

In oracle 8, you can:
alter table _____ deallocate unused;

This removes blocks above the high water mark. It has no effect on blocks below the high water mark.

e_humblot_at_wanadoo.fr wrote:

> You don't have space to create a copy table in your database files,
> but maybe you you have some free space on a separate disk drive.
>
> If so, do as follow :
> Export your table data into an export file on your extra disk drive;
> Truncate your table;
> Import your data.
>
> There is NO WAY to directly remove unused space in a table
Received on Wed Jun 24 1998 - 16:36:09 CDT