Suresh, Google for EXCHANGE PARTITION, and you'll find several helpful procedures. I'm pretty sure you'll need to rebuild your indexes, first deciding whether to make them local or global. Dennis Williams