DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Reuse Storage

  1. #1
    Join Date
    Feb 2001
    Posts
    103

    Smile

    Hi,
    Truncate table "Tablename" Reuse Storage.
    What does Reuse Storage do? Does it keeps the space reserved for the table. Or the table space is released for other tables.
    When the going gets tough, the tough gets going

  2. #2
    Join Date
    Jul 2000
    Location
    india
    Posts
    213
    hi akhil,

    there r two clauses used in conjuction with TRUNCATE command
    1.DROP STORAGE clause
    2.REUSE STORAGE Clause

    The DROP STORAGE clause (default) is used then the space used by the table beyond the initial extents is returned to the tablespace

    The REUSE STORAGE clause is used then the space is retained by the table for reuse.The space freed in the associated indexes is reused as well

    Hope this will help u.

    pras

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