Thanks for replying .
I am rephrasing my question.
I have 3 tables in production which have around 200 partitions each beginning from 2003.
I would like to move any data from all 3 tables onto a different schema and different tables that is prior to 1/1/2008.
What would be the best way ?
thanks you