Difference between Traditional Exp/Imp and Datapump(Expdp/Impdp).
There are a lots of different between old traditional utlity and expdp. Below are main difference----
1-Datapump operates on a group of files called dump file sets. However, normal export operates on a single file.
2-Datapump access files in the server (using ORACLE directories). Traditional export can access files in client and server both
(not using ORACLE directories).
3-Exports (exp/imp) represent database metadata information as DDLs in the dump file, but in datapump, it represents in XML document format.
4-Datapump has parallel execution but in exp/imp single stream execution.
5-Datapump does not support sequential media like tapes, but traditional export supports.
6-Impdp/Expdp use parallel execution rather than a single stream of execution, for improved performance.
7-Data Pump will recreate the user, whereas the old imp utility required the DBA to create the user ID before importing.
8-In Data Pump, we can stop and restart the jobs.
9-Expdp/Impdp consume more undo tablespace than original Export and Import.
10.Data Pump does not use the BUFFERS parameter.
No comments:
Post a Comment