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
5676 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

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers CTS,

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers

what is the use of ocr?

0 Answers Oracle,

how can you implement fine-grained auditing?

0 Answers Oracle,

What is the dataguard background process??

1 Answers iGate,

From the database level, how can you tell under which time zone a database is operating?

1 Answers

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers DELL, TCS,

When a user process fails, what background process cleans up after it?