1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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


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 different types of indexes available in sql server? : sql server DBA

0 Answers  

If CPU is very slow What can u do to speed up?

1 Answers  

Name two files used for network connection to a database.

5 Answers  

What view would you use to determine free space in a tablespace?

3 Answers  

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,




Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

What is dbcc? : sql server DBA

0 Answers  

What is fill factor? : sql server DBA

0 Answers  

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,

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

0 Answers  

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

For more DB Administration Interview Questions Click Here
Categories