Using Exp/imp to import Oracle 11g data to Oracle 9i

Now there is a need to use Exp/imp to import 11g of database data into 9i, to solve this problem generally think of three ways of thinking, try (in fact, from the high version of the server to support the low version of the client principle, you can probably guess the use of 9i client to handle the problem)

Method 1: Export imports all use 11g clients

--11G Client Export

[Oracle@xifenfei ~]$ exp Chf/xifenfei file=/tmp/t_xifenfei.dmp

>log=/tmp/t_xifenfei.log Tables=chf.t_xifenfei

Export:release 11.2.0.3.0-production on Fri 18 18:15:18 2012

Copyright (c) 1982, Oracle and/or its affiliates. All rights reserved.

Connected to:oracle Database 11g Enterprise Edition release 11.2.0.3.0-production

With the partitioning, OLAP, Data Mining and real application testing options

Export done in ZHS16GBK character set and Al16utf16 NCHAR character set

Server uses Al32utf8 character set (possible charset conversion)

About to export specified tables via conventional Path ...

. . Exporting table T_xifenfei 2 rows exported

Export terminated successfully without warnings.

--11G Client Import

[Oracle@xifenfei ~]$ Imp chf/xifenfei@ora9i file=/tmp/t_xifenfei_11g.dmp

>log=/tmp/t_xifenfei.log Tables=chf.t_xifenfei

Import:release 11.2.0.3.0-production on Fri 18 18:17:24 2012

Copyright (c) 1982, Oracle and/or its affiliates. All rights reserved.

Imp-00058:oracle Error 6550 encountered

Ora-06550:line 1, Column 33:

Pls-00302:component ' set_no_outlines ' must be declared

Ora-06550:line 1, Column 7:

Pl/sql:statement ignored

Imp-00000:import terminated unsuccessfully

This error is due to version incompatibility: pls-00302:component ' set_no_outlines ' must be declared

Method 2:11g Client export, 9i client Import

--11G Client Export

[Oracle@xifenfei ~]$ exp Chf/xifenfei file=/tmp/t_xifenfei.dmp

>log=/tmp/t_xifenfei.log Tables=chf.t_xifenfei

Export:release 11.2.0.3.0-production on Fri 18 18:15:18 2012

Copyright (c) 1982, Oracle and/or its affiliates. All rights reserved.

Connected to:oracle Database 11g Enterprise Edition release 11.2.0.3.0-production

With the partitioning, OLAP, Data Mining and real application testing options

Export done in ZHS16GBK character set and Al16utf16 NCHAR character set

Server uses Al32utf8 character set (possible charset conversion)

About to export specified tables via conventional Path ...

. . Exporting table T_xifenfei 2 rows exported

Export terminated successfully without warnings.

--Transfer to 9i

[Oracle@xifenfei tmp]$ SCP t_xifenfei.dmp 192.168.1.10:/tmp/

The authenticity of host ' 192.168.1.10 (192.168.1.10) ' can ' t be established.

RSA key fingerprint is 3d:0c:d1:4b:45:bd:a3:f5:25:eb:4d:52:d2:32:03:69.

Are you sure your want to continue connecting (yes/no)? Yes

warning:permanently added ' 192.168.1.10 ' (RSA) to the list of known hosts.

oracle@192.168.1.10 ' s Password:

T_xifenfei.dmp 100% 56KB 56.0kb/s 00:00