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

Thread: truncating partition

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    211
    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 8.1.6.0.0 with OPS on Compaq Tru64
    Thanks
    manjunath

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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
    Posts
    211
    Thanks, Jmodic. Probably, I dont need to sue the drop storage.
    manjunath

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