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 18.104.22.168.0 with OPS on Compaq Tru64
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.
Thanks, Jmodic. Probably, I dont need to sue the drop storage.