一、把11g数据导入到10g数据库中(expdp/impdp)
1.在11g连接并创建目录和授权
C:\Users\JACK>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on 星期六 11月 3 10:41:14 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create directory emp_dir as 'E:\app\exp';
目录已创建。
SQL> grant read ,write on directory emp_dir to public;
授权成功。
SQL> exit
从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开2.导出11g数据
2.进行导出
C:\Users\JAMES>expdp hr/hr directory=emp_dir dumpfile=emp.dump tables=emp_bak version=10.2.0.1.0
Export: Release 11.2.0.1.0 - Production on 星期六 11月 3 10:42:27 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
启动 "HR"."SYS_EXPORT_TABLE_01": hr/******** directory=emp_dir dumpfile=emp.dump tables=emp_bak ve
rsion=10.2.0.1.0
正在使用 BLOCKS 方法进行估计...
处理对象类型 TABLE_EXPORT/TABLE/TABLE_DATA
使用 BLOCKS 方法的总估计: 64 KB
处理对象类型 TABLE_EXPORT/TABLE/TABLE
处理对象类型 TABLE_EXPORT/TABLE/STATI