On 25-03-2010 3:44 PM, Andhi Rahman wrote: > Saya pernah mencoba import di oracle 8 menggunakan hasil export oracle 10G > tidak bisa , tetapi kalo sebaliknya bisa. Tentu saja karena tidak di support harus pakai 2 step ke versi 9 dulu baru ke 8
Saya coba copy kan table matrix EXP-IMP source dari : metalink https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=132904.1 Matrix 1: Which Export client to use when importing into an Oracle 9.0.1, or an Oracle 8.1.6 or a lower release target database (always use the Import client of the target database): +-----------+--------------------------------------------------------------+ | EXPORT | IMPORT into: | | from +--------+--------+--------+--------+--------+--------+--------+ | \/ | 5.x | 6.x | 7.x | 7.3.x | 8.0.x | 8.1.x | 9.0.1 | +-----------+--------+--------+--------+--------+--------+--------+--------+ | 5.x 1) 2)| EXP5x | EXP5x | EXP5x | EXP5x | EXP5x | EXP5x | EXP5x | | 6.x 2)| N/S | EXP6x | EXP6x | EXP6x | EXP6x | EXP6x | EXP6x | +-----------+--------+--------+--------+--------+--------+--------+--------+ | 7.0.x 3)| N/S | EXP6x | EXP7x | EXP70x | EXP70x | EXP70x | EXP70x | | 7.1.x 3)| N/S | EXP6x | EXP7x | EXP71x | EXP71x | EXP71x | EXP71x | | 7.2.x 3)| N/S | EXP6x | EXP7x | EXP72x | EXP72x | EXP72x | EXP72x | | 7.3.x 3)| N/S | EXP6x | EXP7x | EXP73x | EXP72x | EXP73x | EXP73x | +-----------+--------+--------+--------+--------+--------+--------+--------+ | 8.0.x 4)| Not Supported | EXP7x | EXP73x | EXP80x | EXP80x | EXP80x | | 8.1.x 4)| Not Supported | EXP7x | EXP73x | EXP80x | EXP81x | EXP81x | +-----------+--------+--------+--------+--------+--------+--------+--------+ | 9.0.1.x | Not Supported | 5) | EXP81x | EXP901 | | 9.2.0.x | Not Supported | 5) | N/S | EXP901 | +-----------+--------+--------+--------+--------+--------+--------+--------+ | 10.1.0.x | Not Supported | EXP901 | | 10.2.0.x | Not Supported | N/S | +-----------+--------+--------+--------+--------+--------+--------+--------+ | 11.1.0.x | Not Supported | +-----------+--------+--------+--------+--------+--------+--------+--------+ 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 Oracle7 Import client: see the Oracle Utilities Manual, Chapter 2 "Import" for special considerations to keep in mind. 3) To export from Oracle7 for import into an Oracle6 database: user SYS must run script CATEXP6.SQL on the Oracle7 database first (this script needs to be run only once to have the version6 views been created). 4) To export from Oracle8, Oracle8i for import into an Oracle7 database: user SYS must run script CATEXP7.SQL on the Oracle8/8i database first (this script needs to be run only once in order to create the version7 views). 5) Only the terminal Oracle8 release (8.0.6) was supported against an Oracle9i database: to export from Oracle9i and import into 8.0.6, use the Oracle8 Export client. Matrix 2: 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 | | +-----------+--------+--------+--------+--------+--------+-----------------+ | 5.x 1)2)| EXP5x | EXP5x | EXP5x | EXP5x | EXP5x | | | 6.x 2)| EXP6x | EXP6x | EXP6x | EXP6x | EXP6x | | | 7.x 3)| EXP7x | EXP7x | EXP7x | EXP7x | EXP7x | | +-----------+--------+--------+--------+--------+--------+-----------------+ | 8.0.3 | EXP803 | EXP803 | EXP803 | EXP803 | EXP803 | | | 8.0.4 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | | | 8.0.5 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | | | 8.0.6 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | | +-----------+--------+--------+--------+--------+--------+-----------------+ | 8.1.5 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | | | 8.1.6 | EXP816 | EXP816 | EXP816 | EXP816 | EXP816 | | | 8.1.7 | EXP817 | EXP817 | EXP817 | EXP817 | EXP817 | | +-----------+--------+--------+--------+--------+--------+-----------------+ | 9.0.1 | EXP817 | EXP901 | EXP901 | EXP901 | EXP901 | | | 9.2.0 | EXP817 | EXP920 | EXP920 | EXP920 | EXP920 | | +-----------+--------+--------+--------+--------+--------+-----------------+ | 10.1.0 4)| EXP817 | EXP920 | 4) | | | 10.2.0 4)| N/S | EXP920 | 4) | | +-----------+--------+--------+--------+--------+--------+-----------------+ | 11.1.0 4)| N/S | EXP920 | 4) | 5) | | +-----------+--------+--------+--------+--------+--------+-----------------+ 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.
