Re: truncate command internal behavior
- From: rjamya <rjamya@xxxxxxxxx>
- To: Harvinder.Singh@xxxxxxxxxxxxx
- Date: Tue, 17 Oct 2006 11:20:33 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
