Re: Update a table with no logging?

"Brian Peasland" <peasland_at_usgs.gov> wrote in message news:3B029354.B30C1118_at_usgs.gov...
>
> > 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.
>

That's true... I forgot about the REUSE option. Thanks, Brian.

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

(Nope -you're right).

> 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!
> ========================================
Received on Wed May 16 2001 - 16:27:15 CDT