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 resumeable 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 an application programming interface (API), which is the DBMS_DATAPUMP package. This allows us to customize datapump operations with code, unlike EXP/IMP.
6. Datapump only works on the server side, generating output there because of the directory parameter, while EXP/IMP can run from the client side.
7. Datapump can estimate the output file size without running it, unlike EXP/IMP.