Home What is Oracle? Oracle Training Tutorials for Beginners Difference Between Oracle 11g and 12c and 10g Import 12c Oracle Dump to 11g Ora 28001 The Password Has Expired Error Cache and Nocache in Oracle Sequence BR*Tools Documentation ORA-01455: Converting Column Overflows Integer Datatype Oracle Wait Events Interview Questions Difference Between Primary, Secondary and Clustered Indexes in DBMS Difference Between Hot and Cold Backup Oracle Partitioning Interview Questions Update Statement Works in Oracle Architecture Differences Between SAP HANA and Oracle Group Functions Ignore Null Values in Processed Column ORA-10458: Standby Database Requires Recovery Oracle Interview Questions

How to Export Heave Files to 3 Different Mount Points?

Updated May 18, 2018

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!

Comments

19 Aug 2015 4:32 pm Nitesh Singh

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 Jyoti Pandey

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

19 Aug 2015 4:32 pm Sugandh

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

19 Aug 2015 4:33 pm Chandan Singh Parihar

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

19 Aug 2015 4:33 pm Romil Tripathi

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 Sushma

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