Import data into Oracle8i or higher release database. import export compatibility matrix Which Export client to use when importing into an Oracle8i 8.1.7
or a higher release target database
(always use the Import client of the target database):
+-----------+--------------------------------------------------------------+
| EXPORT | IMPORT into: |
| from +--------+--------+--------+--------+--------+-----------------+
| \/ 8.1.7 |9.2.0 |10.1.0 |10.2.0 |11.1.0 |11.2.0 | |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 5.x 1)2) | EXP5x | EXP5x | EXP5x | EXP5x | EXP5x | EXP5x | |
| 6.x 2) | EXP6x | EXP6x | EXP6x | EXP6x | EXP6x | EXP6x | |
| 7.x 3) | EXP7x | EXP7x | EXP7x | EXP7x | EXP7x | EXP7x | |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 8.0.3 | EXP803 | EXP803 | EXP803 | EXP803 | EXP803 | EXP803 | |
| 8.0.4 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | |
| 8.0.5 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | |
| 8.0.6 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 8.1.5 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | |
| 8.1.6 | EXP816 | EXP816 | EXP816 | EXP816 | EXP816 | EXP816 | |
| 8.1.7 | EXP817 | EXP817 | EXP817 | EXP817 | EXP817 | EXP817 | |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 9.0.1 | EXP817 | EXP901 | EXP901 | EXP901 | EXP901 | EXP901 | |
| 9.2.0 | EXP817 | EXP920 | EXP920 | EXP920 | EXP920 | EXP920 | |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 10.1.0 4)| EXP817 | EXP920 |
| 10.2.0 4)| N/S | EXP920 |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 11.1.0 4)| N/S | EXP920*|
| 11.2.0 4)| N/S | EXP920*|
+-----------+--------+--------+--------+--------+--------+--------+--------+
Remarks:1) Import can read export dump files created by EXPORT release 5.1.22 and higher (up to same version).
2) An Oracle5 or Oracle6 export dump and an Oracle8 or Oracle8i or Oracle9i Import: see the Oracle Utilities Manual, Chapter 2 "Import" for special considerations to keep in mind.
3) An Oracle7 export dump and an Oracle8 or Oracle8i or Oracle9i Import: check constraints on the DATE columns become invalid when TO_DATE function has not been used in the constraint (this was not required in earlier Oracle versions).
4) To have a better performance and more flexibility when exporting from and importing into Oracle10g and higher release databases, we recommend the usage of the Export Data Pump (expdp) and Import Data Pump (impdp) clients.
5) The original Export client is desupported for general use as of Oracle Database 11g.
