Data Integration

Get Involved. Join the Conversation.

Topic

    Bjain
    Merge datapump files
    Topic posted February 5, 2018 by Bjain  
    30 Views
    Title:
    Merge datapump files
    Summary:
    Merge datapump files
    Content:

    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