-
Truncate with Reuse Storage
Guys,
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
released blocks?
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.
Thanks
sumit
-
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.
Tamil
-
You badly need concepts guide.. Ok, here is the link for you
Oracle 9.x Concepts
funky...
"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"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|