DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2000
    Hi Friends,
    One of the partitions of a table in the production database had missed some portion of the data. So, it has to be reloaded entirely. So I need to truncate this partition, free up the space and allow the reload. I had some doubts about 'drop storage' and 'reuse storage' clauses of alter table. I think the following should be my solution:
    alter table table_name truncate partition partition_name drop storage;
    Can someone confirm?
    I am using with OPS on Compaq Tru64

  2. #2
    Join Date
    Dec 2000
    Ljubljana, Slovenia
    If you want to change some storage parameters after the TRUNCATE or if you think there data will be packed into fewer extents after the reload, then using DROP STOREG would be OK.

    But if neither of the above is true then there is no point in using DROP STORAGE. In fact, if there is a lot of extents to be re-alocated during the reload proces then DROP STORAGE will slow the reload down a little.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Oct 2000
    Thanks, Jmodic. Probably, I dont need to sue the drop storage.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.