what is datapump? Difference between exp and expdp?

Question Posted / syed.maxud@gmail.com

2 Answers
20433 Views
Capital IQ, TCS, WNS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is datapump? Difference between exp and expdp?..

1. you can deattach or reattch datapump job.
2. you can parallelise datapump job [PARALLEL=4]
3. without export can do import using NETWORK_LINK parameter
4. can calculate export dump file size using ESIMATE_ONLY
5. expdp utility used which is caled by dbms_datapump
procudure
6. remapping capabilities during import
[REMAP_DATAFILE,EMAP_SCHEMA,REMAP_TABLESPACE,REUSE_DATAFILES
]

Is This Answer Correct ?

30 Yes

7 No

what is datapump? Difference between exp and expdp?..

Answer / dba

Here you can see more details..
http://shonythomas.blogspot.in/2012/02/datapump-vs-expimp-difference-or.html

Is This Answer Correct ?

1 Yes

1 No

Post New Answer

More Database Management Interview Questions

dear all,Greetings of the day.. i have a small query plz rply if u knw.. i have done MBA Hr and B.sc microbiology. i am very much interested in it industry,so i am planing to go with oracle HRMS module,can it be work out??

0 Answers

what are the different levels of database schema?

0 Answers Infosys,

What are the two types of indexes and explain them in detail? Or what's the difference between clustered and non-clustered indexes?

0 Answers

How data are stored in database?

0 Answers

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name, price 101, LED Lights,200 102, 20 watt CFL Lights, 145 103, 30 watt CFL lights,155 Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence flat file product list has two column pro_name, price 20 watt tube light ,45 30 watt tube light ,60

1 Answers TCS,

Explain about cursors?

0 Answers

What is rdbms architecture?

0 Answers

IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?

0 Answers

How do you exit a database?

0 Answers

What is tuple and attribute?

0 Answers

How can you get the alternate records from the table in the sql?

0 Answers

What are the different technologies used to access Database from Visual Basic?

0 Answers CGI,

For more Database Management Interview Questions Click Here