Is there a way i can export just subset of data from a partitioned table
I am running EE oracle database version 12.1.0.2. I have a huge table that is over 60TB in size with lots of partitions created over time based on date. However, i need to extract subset of data to load to another database. For this, i have been able to put in place an expdp query that really meets my need.
The problem is that when i submitted this parfile to the expdp to run, i noticed that it will export the definitions of all the partitions, and because i have large numbers of partitions in this table, it makes my dumpfile to be huge as it goes through every partition and get the numbers of records that qualifies and make it part of the dumpfile. I do not want this at all because all i need are just the data without the partition definition. I plan on putting the data subset into another table that will be unpartitioned.