ORACLE11G export DMP Import to 11g__oracle

First, on the 11g server, use the EXPDP command to back up the data

11g Export statement: EXPDP userid= ' facial/facial@orcl as Sysdba ' schemas=facial directory=data_pump_dir dumpfile=aa.dmp logfile= Aa.log version=10.2.0.1.0

Where my username is facial, the password is facial, the database SID is Orcl,schemas the username to be exported is facial, to be imported into the 10.2.0.1.0 version of the Oracle database. Aa.dmp and Aa.log will be generated in the 11g Dpdump directory, such as my 11g installed under E disk, so aa.dmp will be generated in the E:\app\Administrator\admin\orcl\dpdump directory.


Second, on the 10g server, use the IMPDP command to recover data

Preparation: 1. Build the Library 2. Create a table Space 3. Build users and authorize 4. Copy Aa.dmp to 10g Dpdump directory

10g import statement: IMPDP userid= ' facial/facial@orcl as Sysdba ' schemas=facial directory=data_pump_dir dumpfile=aa.dmp logfile= Aa.log version=10.2.0.1.0