8 Replies Latest reply: Nov 20, 2012 2:56 AM by Dean Gagne RSS

    Datapump: can dumpfiles get copied when datapump export is still running?

    vivalavida
      Hi ,

      let's define that a datapump export with the settings

      DUMPFILE=exportdp_DUMPFILE_%U.dmp
      FILESIZE=2G
      PARALLEL=2

      will generate 20 dumpfiles of size 2G each. The datapump-worker will create two dumpfiles in parallel and write to both parallel. As soon as a dumpfile has a size of 2G, the next file will get created and data will get written into.
      My question now is:
      can the files, which already have the size of 2G, get copied to another server? That would have the advantage that I don't have to wait until the end of the datapump export before starting the filetransfer to another server. That ability would certainly save some time and speedup the datapump export-/import-process...
      Or must I wait until the end of the datapump export before files can get copied - just because the datapump will update those files with "something"?

      Any help will be appreciated

      Rgds
      JH