Truncate with Reuse Storage
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Truncate with Reuse Storage

  1. #1
    Join Date
    Dec 2001
    Posts
    203

    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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    how about instead of spend your time writing and waiting RTFM???

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    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

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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
  •  



Click Here to Expand Forum to Full Width