February 12, 2013 at 8:41 am
I'm wanting to modify the boundries of an active partition. Basically moving it from 100,000,000 to 300,000,000 (assume autoID) currently I have 4.2B in the table across 25 files. The issue is that the final file is currently holding 1.9B alone. We're wanting to redistrubute it across the whole partition scheme. Any sites or links would be wonderfully helpful. I see alot of items on how to create, I dont see very many on modification of an existing, runaway partition. Thanks in advance!
.
February 12, 2013 at 9:51 am
I'm looking for something specifically like...
We'll call the partition PF_Help ^.^;
alter partition boundary_id value = 75000000
the question I guess is, will I expect dataloss if i just change the value?
currently I have a result from select * from sys.partition_range_values as
function ID boundary_id parameter_id value
55555 1 1 25000000
55555 2 1 50000000
55555 3 1 75000000
55555 4 1 100000000
as an example.
My ultimate end goal is to have all values scale by 75m vs the current 25m.
I hope i'm not bouncing around too much.
.
February 12, 2013 at 10:14 am
Final question to add, is it better to fix the partition issue where the final partition is massive, or is there any gain over just adding 5 new files to the final FG and spreading the whole section around those 5 files.
.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply