Truncate with Reuse Storage
I have read few documents and notes from forum, which says to improve TRUNCATE operation it is good to use 'REUSE STORAGE' option.
I would like to clarify the followings
1) If multiple tables are associated with one single tablespace, and if I truncate one table with reuse storage ---
a) Is it true that all the old blocks only be used
for new inserts in that table only?
b) Can other tables in that tablespace can use those
c) What about the HWM? Will that reduce?
2) If I have a single table associated with single tablespace
a) Reuse storage will not reduce the current HWM even
after truncating - is that true? for example if my the HWM
is set to 2GB now, and if I truncate table with Reuse
Storage will that help to reduce my HWM?
b) Will this option help to defragment my tablespace.
how about instead of spend your time writing and waiting RTFM???
After "truncate table reuse storage" command is executed, the HWM will be reset to the beginning block. Hence, new rows will reuse the deleted space.
You badly need concepts guide.. Ok, here is the link for you
Oracle 9.x Concepts
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Click Here to Expand Forum to Full Width