Shulou(Shulou.com)06/01 Report--

How to migrate 11g data to 10g platform through expdp and impdp. Aiming at this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

Today, it is found that the target database host to be imported is 10g, while the source data host is 11g. To complete the migration, you need to use the new functional data pump added by oracle in 10g, because in 11g, the data pump can define the version of the exported file, namely version. Now write down the main 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, 2010, Oracle. All rights reserved.

SQL > conn system/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 > expdp system/windows@orcl schemas=scott directory=dump_

Dir dumpfile=scott.dmp logfile=exp.log version=10.2.0.3.0

C:\ Windows\ system32 > impdp system/windows@orcl schemas=scott directory=dump_d

Ir dumpfile=scott.dmp logfile=imp.log version=10.2.0.3.0

This is the answer to the key questions on how to migrate 11g data to 10g platform through expdp and impdp. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.