Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to be freed EXTENTED space?
And if this doesn't do the job, just export, drop and then re-import the
table. Oh, and make sure your 'initial extent' settings don't go and grab
large amounts of space you aren't going to use.
MotoX
John P. Higgins wrote in message <35917149.DBEDF36F_at_deere.com>...
>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 Thu Jun 25 1998 - 02:50:24 CDT