We have a partition table on Production environment with 2338117620 rows and 206 partitions. Now we have to copy only last 2 year data in Test environment.
But the problem is that , Import Export utility does not copy partition tables the same way in target database even if we have created the same partition reference on the target database.
So, now we have only one option left is that of Bulk-copy. But not sure if bulk copy supports exporting partition data to a target partitioned table. Do let me know your thoughts on it.