Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: fastest way of deleting all rows in a table
On Sat, 1 Mar 2003 09:48:55 +1000, "Richard Foote"
<richard.foote_at_bigpond.com> wrote:
>Hi Kenneth,
>
>Don't confuse keeping the allocated extents (for subsequently reused) to the
>resetting of the HWM.
>
>Truncate *always* resets the HWM.
>
>Cheers
>
>Richard
Hi Richard,
Ok, I'll be accurate as well :-)
What I meant was : When truncating with "drop storage", HWM will be
reset and drop down to the initial extent. When truncating with "keep
storage", HWM will not drop down, but still be reset within the last
allocated extent. So I said "reset" while meaning "drow down".