[font="Verdana"]

Hi

Thanks for the reply.

If you mean:

ALTER TABLE Transaction_Summary

SWITCH TO Transaction_Summary_2

ON TranactionSummary_Schema

This is not the correct syntax. Also it doesnt make sense to specify a partition number because I have created a partitioned table so the data based on the partition key will get divided inti different partitions and if i specify a partition number then the transfered data wont be partitioned!!!so what will be the benefit of all this effort to partition it!!!

Regards,

Hooman

[/font]