Key Points of migrating 11G data to 10g platform through expdp & amp; impdp

The target database host to be imported is 10 Gb, and the source data host is 11 GB. To complete the migration, you need to use the function data pump added by Oracle in 10 Gb, in 11g, the data pump can define the version of the exported file. Now let's write down the points below for your reference:

C: \ Windows \ system32> sqlplus/nolog

SQL * Plus: Release 11.2.0.1.0 Production on Wednesday April 3 09:32:26 2013

Copyright (c) 1982,201 0, Oracle. All rights reserved.

SQL> connsystem/windows @ orcl
Connected.
SQL> Create directory dump_dir as 'e: \ studydemo \ oracle \ dumpdir ';

The directory has been created.

SQL> grant read, write on directory dump_dir to scott;

Authorization successful.

SQL> exit
C: \ Windows \ system32> expdpsystem/windows @ orclschemas = scott directory = dump _
Dir dumpfile = scott. dmp logfile = exp. log version = 10.2.0.3.0

 

C: \ Windows \ system32> impdpsystem/windows @ orclschemas = scott directory = dump_d
Ir dumpfile = scott. dmp logfile = imp. log version = 10.2.0.3.0