Re: Update a table with no logging?

> Just want to verify: TRUNCATE TABLE does not deallocate the blocks assigned
> to the table, right? I have used truncate and then re-analyzed the
> truncated table and found that there was still the same number of blocks
> allocated, even though there were no rows.

I just read this yesterday (but can't recall where), that the TRUNCATE TABLE will drop all but the initial extent. This assumes that you don't use the REUSE option of the command which will retain all extents. If your table has only one extent, then you will not see a reduction in the total number of blocks.

Feel free to correct me if what I read was wrong!

Thanks,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================