Forum Stats

  • 3,733,981 Users
  • 2,246,853 Discussions
  • 7,856,964 Comments

Discussions

Merge datapump files

Hi ,

I have a requirement to export and later import table partitions using dbms_datapump API. Going by the standard process, this will create separate .dmp and .log files for each partition.

However, we want all these partitions to be created in a single .dmp and .log file. For example:

Table T1 has partitions P1, P2 and P3

Normal approach --> dbms_datapump API call ---> P1.dmp, P2.dmp and P3.dmp (corresponding log files as well)

To be achieved ---> dbms_datapump API calls ----> Consolidated one dump file for (P1,P2,P3) and one log file.

I tried EXCLUDE partitions as well, but that also did not work.

Any helpful tips/leads are welcome.

Thanks

Sign In or Register to comment.