Re: fastest way of deleting all rows in a table

On Fri, 28 Feb 2003 16:56:46 GMT, Stan <stan0074_at_yahoo.com> wrote:

>Ed Stevens wrote:

<snip>
>>
>> Truncate resets the high-water mark -- a simple pointer change. It
>> doesn't generate any redo, and so is not recoverable.
>>
>
>sorry, its still generates redo but it would be very minimal (segment
>header changes...fet$/uet$ changes, if using dictionary managed tablespace)
>

<snip>

Point taken. Thanks for the clarification. Received on Fri Feb 28 2003 - 13:14:09 CST