try alter table X deallocate unused KEEP 1K. I think this will drop all of the extents except the first one. THen you can make your next extent nice and big. Is 2 extents close enough?
|
Results 1 to 6 of 6
Thread: resetting # of extentsThreaded View
|
Click Here to Expand Forum to Full Width |