4 Replies Latest reply: Dec 13, 2012 10:54 PM by Osama_Mustafa RSS

    EXPDP Help

    977214
      Hi All,

      PLease help to do one export dump file.
      Details are:-

      Estimated Size of DUmp file is:-160GB

      Requirement is to create 3 dump files in 3 different mount points which each dump file having size 54 gb

      Please help to do this expdp...
        • 1. Re: EXPDP Help
          CloudDB
          You can create multiple export dumps using datapump export.
          expdp scott/******* dumpfile=expdir:filepart%u.dmp,reorg:filepart%u.dmp parallel=2 tables=hits_in logfile=reorg:logfile.exp

          multiple EXPDP directories

          Edited by: hitgon on Dec 13, 2012 3:57 PM
          • 2. Re: EXPDP Help
            Osama_Mustafa
            You cannot split the dumpfiles to multiple locations.since Export/import Reads from one directory only . But as work around you can use FILESIZE=54G but if you check the following thread you will there's workaround to split using export/import and its posted before by other user
            expdp webrep/******* dumpfile=expdir:filepart%u.dmp,reorg:filepart%u.dmp parallel=2 tables=hits_in logfile=reorg:logfile.exp
            Check
            multiple EXPDP directories

            Edited by: Osama_mustafa on Dec 13, 2012 2:42 PM
            • 3. Re: EXPDP Help
              Raj Jamadagni
              Osama_mustafa wrote:
              You cannot split the dumpfiles to multiple locations.
              Why? The manual begs to differ, dumpfile syntax is
              DUMPFILE=[directory_object:]file_name [, ...]
              which means it is possible to say
              dumpfile=dir1:file1,dir2:file2,dir3:file3 optionally you can add parallel clause as well. 
              Raj
              • 4. Re: EXPDP Help
                Osama_Mustafa
                rjamya wrote:
                Osama_mustafa wrote:
                You cannot split the dumpfiles to multiple locations.
                Why? The manual begs to differ, dumpfile syntax is
                DUMPFILE=[directory_object:]file_name [, ...]
                which means it is possible to say
                dumpfile=dir1:file1,dir2:file2,dir3:file3 optionally you can add parallel clause as well. 
                Raj
                I made simluation for that , and its true you can do it on both expdp and exp

                using exp :
                FILE=Path1/.dmpname.dmp,Path2/.dmpname.dmp,Path3/.dmpname.dmp  FILESIZE=size
                on expdp
                DUMPFILE=expdir:exp%U.dmp