Difference Between EXP/IMP and EXPDP/IMPDP jobs in Oracle

Difference Between EXP/IMP and EXPDP/IMPDP jobs in Oracle

Following are the few points which let us know the difference between EXP/IMP and EXPDP/IMPDP jobs:

1. In Datapump(EXPDP/IMPDP) job we can disconnect from it, its running in background but exp/imp its not possible disconnect means its terminated.

2. We can monitor the Datapump(EXPDP/IMPDP) job by special dictionary view with job name information how far it done etc but EXP/IMP we monitor with v$session_longops view no special view is present for monitoring them.

3. Datapump(EXPDP/IMPDP) job is resume-able if job is terminated then we can resume from that point but not in EXP/IMP job.

4. Datapump(EXPDP/IMPDP) job has parallel option but EXP/IMP not.

5. Datapump has application programming interface (API) i.e DBMS_DATAPUMP package. With this we can custimized the use of datapump operation according to our need by code but not possible in EXP/IMP.

6. Datapump worked only on Server side, it generate output at server side due to directory parameter is use but EXP/IMp has option to run from client side.

7. Datapump has option to estimate the output file without running it but not in EXP/IMP.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.