Oracle 12.1
When performing a metadata-only export of an interval-partitioned table, is there a way to limit which partitions are included? I have tables which are interval partitioned & list subpartitioned with over 30,000 subpartitions each. The export includes details of every subpartition in the export, and as a result is slow and generates a large export file. Since the tables are interval partitioned, I only need the interval specification (i.e. first partition and interval) in order to use the export elsewhere.
Couple of things tried already :
Use the partition specification in the export, e.g. CONTENT=METADATA_ONLY TABLES=MY_TABLE:P_FIRST. This returned the error "ORA-39202: Data cannot be filtered or selected in CONTENT=METADATA_ONLY jobs".
Use a data export, filtering on only the first partition e.g. CONTENT=ALL TABLES=MY_TABLE:P_FIRST. The exports only includes data from the first partition, but still includes the metadata for all the other partitions as with the METADATA_ONLY option, so is no better.