Truncate has to touch storage settings for a table because the way it works. It wipes out information about all extents that belong to the table except the initial one, or another words resets high water mark. This is a reason why it is very fast.
However, if you fo not want it happend you could say
This will keep current storage settings for a table unchanged.Not sure if it takes longer than an usual truncate though.
One, who thinks that the other one who thinks that know and does not know, does not know either!
Reply With Quote