Use of expdp/impdp to back up databases in Oracle

Oracle 10g has introduced the Data pump technology. What are the advantages of this technology and the previous exp/imp technology? In simple terms, the recovery and backup speed are very fast;

Before explaining how to use the data pump, let's first understand the differences between the two:

Before 10 Gb, you can only use the exp/imp command to back up data. From 10 Gb, oracle provides two methods, exp/imp and expdp/impdp. However, before using these methods, we must make it clear:

1. exp/imp are client tools that can be used either on the client or on the server. In other words, you can back up the database on another computer to your computer;

2. expdp/impdp is a server tool. They can only back up the database to the server (that is, you run the command on your computer, but the backup database is still on the server );

3. exp/imp and expdp/impdp cannot be mutually used. That is to say, the database backed up with exp/imp can only be imported using the exp/imp command;

Expdp usage

When you use the expdp command, the exported files can only be stored in the specified directory. Therefore, you need to create a specific directory before use.

The following statement is executed in PL/SQL Command Window.

Create directory dmp_dir as 'd: \ dump; Note: You need to create the corresponding dump directory on the physical d disk.

Grant read, write on directory dump_dir to username

Oracle datapump expdp/impdp hang