Re: truncate command internal behavior

in this case if you must use truncate, I say modify your code slightly to use following syntax (changes in uppercase)

truncate table <table_name> REUSE STORAGE;

Should avoid doing most of the space management related to DROP STORAGE (which is default).

Try that and let us know how it works for you. Raj

--
http://www.freelists.org/webpage/oracle-l