Wednesday, March 4, 2015

Difference between Traditional Exp/Imp and Datapump(Expdp/Impdp)

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

How to create user in MY SQL

Create  a new MySQL user Account mysql > CREATE USER ' newuser '@'localhost' IDENTIFIED BY ' password '...