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 220.127.116.11.0 with OPS on Compaq Tru64
Click Here to Expand Forum to Full Width