|
|
Posted by Hugo Kornelis on 09/30/31 11:32
On Sun, 20 Nov 2005 19:54:45 +0000 (UTC), Erland Sommarskog wrote:
>Hugo Kornelis (hugo@pe_NO_rFact.in_SPAM_fo) writes:
>> A TRUNCATE TABLE operation is minimally logged. That means that there is
>> just enough information in the log file to rollback if the transaction
>> fails or commit if it doesn't - but not enough to re-apply the changes.
>
>Reference?
>
>TRUNCATE TABLE logs the extent deallocations, and that is perfecly
>enough to reapply the changes.
Hi Erland,
mmmm.... 'kay, I guess you're right.
But then, what DOES the quote that Ronin posted mean?
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
Navigation:
[Reply to this message]
|