[font="Verdana"]

Hi

Thanks for your reply. What i didnt get is that why you created the table on one the partitions onle(FG_CHEQ) what about other partitions?just because I thought we should create the table on the schema of a partition function so it covers all partitions.

And also in the ALTER TABLE ... SWITCH if we only specify one partition what happens to the rest of the data?

Regards,

Hooman

[/font]