Re: TRUNCATE Table Command

In article <3s7rij$3ui_at_newsserver.trl.OZ.AU>

           aaj_at_phantom.telecom.com.au "Tony Jambu" writes:

:
: It is documented in the manuals.
:

Here's a funny thing though:

a)	the original initial size is not expliictly stored in 
	the database, so to restore the value, Oracle has to 
	examine the second extent of the table and write back
	its size as the retro-fitted NEXT size.  (You can prove
	this bychanging the NEXT EXTENT size on a table with only
	one extent then truncating it:  NEXT EXTENT is not put back 
	to the original value.)

b)	the PCTINCREASE is not returned to the Original value.
	So how about that for consistency.  (After all Oracle could
	examine the 3rd extent and deduce the original PCTINCREASE
	by comparing it with the second extent)  (NB tongue-in-cheek)

P.S. Whereabouts in the manuals ? I couldn't find it.

-- 
Jonathan Lewis