Online Tutorials & Training Materials |
Register Login

How to Export Heave Files to 3 Different Mount Points?

|| || 6

How to Export Heave Files to 3 Different Mount Points?

Hi Experts,

I have a query if anyone have any solution for that then please try to slove that for me as the query is as follow:
How to Export the file which is size of 30GB, to 3 Different Mount Point which are having free space of 10GB in each. And can I Export the file in to respected Mount Points?

Thank you in Advance!


  • Nitesh Singh
    19 Aug 2015 4:32 pm

    FILE=/exp/prod/exp01.dmp,/exp/prod/exp02.dmp,/exp/prod/exp03.dmp you can try this way to specify the different mount point.

  • 19 Aug 2015 4:32 pm

     But my total dump is 30gb, how it could be spare between those 3 seperate mount points??

  • 19 Aug 2015 4:32 pm

    Using parameter parallel=3 and specifying 3 different directories for dump files.

  • 19 Aug 2015 4:33 pm

    I agree with Sugandh as we can even specify the sizelimit.

  • 19 Aug 2015 4:33 pm

     exp userid=/mountpiont1,/mountpoint2,/mountpoint3 filesize=10g. Use this syntax it will work fine to to store in 3 different mount point each 10g.

  • 19 Aug 2015 4:34 pm

    Use Datapump and below command:

    For Example:

    expdp dumpfile=Dir_1:Dumpfile_1%U.dmp,Dir_2:Dumpfile_1%U.dmp,Dir_3:Dumpfile_3%U.dmp logfile=Dir_1:logfile_name.log schemas=schema_name parallel=3

Related Articles

0.0177 seconds.