I have a huge oracle table of size 3tb which is a date partitioned (partition by range) table starting from 2016. These dates are business dates which does not include weekends and business holidays. Now I need to create a copy of this table with all the data partitions. Is there a easier way to do this with out manually writing all the partitions in the backup script as manually writing create table as select script with those many partitions can lead to mistakes. I looked in to export and import tables but it would take more time considering the size of the table and the back out should be as soon as possible. So, I have ruled out this option. Looking for a better approach that would be less manual and reasonably faster.

I have a huge table of size 3tb which is a date partitioned (partition by range) table starting from 2016. These dates are business dates which does not include weekends and business holidays. Now I need to create a copy of this table with all the data partitions. Is there a easier way to do this with out manually writing all the partitions in the backup script as manually writing create table as select script with those many partitions can lead to mistakes. I looked in to export and import tables but it would take more time considering the size of the table and the back out should be as soon as possible. So, I have ruled out this option. Looking for a better approach that would be less manual and reasonably faster.