- 3,733,981 Users
- 2,246,853 Discussions
- 7,856,964 Comments
- 17.8K All Categories
- 3.3K Industry Applications
- 3.2K Intelligent Advisor
- 57 Insurance
- 533.2K On-Premises Infrastructure
- 137.3K Analytics Software
- 38.5K Application Development Software
- 5.1K Cloud Platform
- 109K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.7K Infrastructure Software
- 105K Integration
- 41.5K Security Software
Merge datapump files
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.