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

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers

How would you begin to troubleshoot an ORA-3113 error?

1 Answers

when does an alert gets signaled?

0 Answers Oracle,

Hot backup procedure?

2 Answers

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers

internal architecture

0 Answers CSC,

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers

How would you determine who has added a row to a table?

4 Answers

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers

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

0 Answers

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

4 Answers DELL, TCS,

For more DB Administration Interview Questions Click Here