Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


why Datapump is faster than traditional export and import

Answers were Sorted based on User's Feedback



why Datapump is faster than traditional export and import..

Answer / nirav gajjar

The Data Pump is a server based utility vs. the traditional
Export / Import which are client based utilities. The
Oracle Data Pump is not compatible with the Export / Import
functionality.

The Oracle Data Pump can also use NETWORK_LINK
functionality to move data and metadata from a remote
database without a dumpfile using the network technology
between the two databases.

Is This Answer Correct ?    18 Yes 1 No

why Datapump is faster than traditional export and import..

Answer / kittu

Datapump has self tuning utilities where as in Exp/imp we need to specify the tuning parameters like buffer & record_length.

While doing datapump job data doesn't travel through the network, it will be done in server side only, so no data transformation through network

Is This Answer Correct ?    12 Yes 3 No

why Datapump is faster than traditional export and import..

Answer / anonymous

We have parameters like parallel to assign number of workers in data pump, but not in exp/imp.
Also Data Pump uses stream pool of SGA.

Is This Answer Correct ?    1 Yes 0 No

why Datapump is faster than traditional export and import..

Answer / rizwan

In traditional datapump exp/imp utility we can not stop the job when it's processing.
whereas in newly expdp/impdp utility we can stop and restart the job
for example, we are exporting the 5 mb size of table and,suppose we want to stop this job so it is possible in expdp but not through exp utility.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More DB Administration Interview Questions

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  


What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,


Give two methods you could use to determine what DDL changes have been made.

2 Answers  


WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,


Name two files used for network connection to a database.

5 Answers  


Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  


What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers  


if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  


What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  


orra 1555 what is this error,why it is occur?

2 Answers   Mphasis,


What's the benefit of "dbms_stats" over "analyze"?

1 Answers  


i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers   Infozech, Wipro,


Categories