-
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
-
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?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|