i want export 50gb data in datapump it will take 2 hours time to complete that h

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

Question Posted / 999ysuman

1 Answers
5643 Views
iGate, I also Faced
E-Mail Answers

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that..

Answer / mohapatra.gouranga@gmail.com

You should implement parallelisim
e.g.,
expdp full=y directory=data_pump dumpfile=dumpfile%U.dmp
logfile=logfile_exp.log parallel=5 filesize=10G
exclude=statistics

Is This Answer Correct ?

4 Yes

1 No

Post New Answer

More DB Administration Interview Questions

how can you get actual data change values from previous transactions in oracle?

0 Answers Oracle,

What is dcl? : sql server DBA

0 Answers

What purpose does the model database server? : sql server DBA

0 Answers

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers

wat is global index and local indes

1 Answers Oracle,

What types of replication are supported in sql server? : sql server DBA

0 Answers

what is the difference between db2start command and start database manager command?

1 Answers

what is incremental checkpoint?

1 Answers CTS,

what do you understand by fine-grained auditing?

0 Answers Oracle,

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers Tech Mahindra,

For more DB Administration Interview Questions Click Here