Re: Truncate and free space

devjnr_at_gmail.com wrote:
> I tried to truncate a table that was 2,200 KB.
>
> Using EM and refreshing table segments to see new used space I instead
> continue to see full 2,200 KB sized table.
>
> Then I do the following:
>
> 1) Log off from EM
> 2) Log on to EM
> 3) View table segments and now I can see correctly new used space:
>
> Used: 8.00
> Allocated: 64.00
>
>
> Is this behavior correct?
>
> Thx to all.
>

Do you know the exact syntax of your TRUNCATE command? If you specified the REUSE STORAGE clause, the space will not be freed. The default is to DROP STORAGE which will reclaim that free space.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown