Oracle 19c – Expdp Partitioned Table and Impdp Into Non-Partitioned Table

The performance benefits of partition pruning depend on the proportion of rows being selected from the table and the efficiency with which the rows can be isolated to their own partition(s).

If you are selecting 5% of a table's rows and those rows are isolated into a subset of partitions then selecting them is generally going to be around twenty times faster than a full table scan. On the other hand, selecting them via an index could be more or less efficient than a full table scan, but is not going to approach twenty times as fast except maybe in very particular circumstances (perfect clustering of values, bitmap index access, SSD storage ...).

There's virtually no overhead to inserting into a partitioned table. One advantage of partitioning when it comes to inserts is that it can allow multiple simultaneous direct path inserts to the table, which is impossible on a non-partitioned table as the insert would require a segment-level exclusive lock.

_{Community Wiki answer compiled from comments to the question}^†

Jon Seigel:

It isn't possible to restore a database that uses Enterprise edition features on an instance that doesn't support those features. You'll have to either remove partitioning and then use backup/restore, or export/import the data.

Kin

See this answer on another question that shows how to use bcp out and BULK INSERT in native mode to transfer the data quickly.

^†_{Comments may be deleted and are not searchable.}