Re: Import 11g dump in 9i

From: Jack <none_at_INVALIDmail.com>
Date: Thu, 20 Mar 2008 10:13:02 GMT
Message-ID: <OMqEj.63$2f2.52@read4.inet.fi>

Summary Export/Import compatibility:

1. Export the data with the Export utility of the lowest database version involved.
2. Import the data with the Import utility of the target database.

Matrix 2: Which Export client to use when importing into an Oracle8i

           or a higher database release
          (always use the Import client of the target database):

+-----------+--------------------------------------------------------------+


|  EXPORT   |                          IMPORT into: 

|
| from +--------+--------+--------+--------+--------+--------+--------+
| \/ | 8.1.x | 8.1.7 | 9.0.1 | 9.2.0 | 10.1.0 | 10.2.0 | 11.1.0
|

+-----------+--------+--------+--------+--------+--------+--------+--------+
| 5.x 1) 2)| EXP5x | EXP5x | EXP5x | EXP5x | EXP5x | EXP5x | EXP5x
|
| 6.x 2)| EXP6x | EXP6x | EXP6x | EXP6x | EXP6x | EXP6x | EXP6x
|
| 7.x 3)| EXP7x | EXP7x | EXP7x | EXP7x | EXP7x | EXP7x | EXP7x
|

+-----------+--------+--------+--------+--------+--------+--------+--------+
| 8.0.3 | EXP803 | EXP803 | EXP803 | EXP803 | EXP803 | EXP803 | EXP803
|
| 8.0.4 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804
|
| 8.0.5 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805
|
| 8.0.6 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806
|

+-----------+--------+--------+--------+--------+--------+--------+--------+
| 8.1.5 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815
|
| 8.1.6 | EXP81x | EXP816 | EXP816 | EXP816 | EXP816 | EXP816 | EXP816
|
| 8.1.7 | EXP81x | EXP817 | EXP817 | EXP817 | EXP817 | EXP817 | EXP817
|

+-----------+--------+--------+--------+--------+--------+--------+--------+
| 9.0.1 | EXP81x | EXP817 | EXP901 | EXP901 | EXP901 | EXP901 | EXP901
|
| 9.2.0 | N/S | EXP817 | EXP901 | EXP920 | EXP920 | EXP920 | EXP920
|

+-----------+--------+--------+--------+--------+--------+--------+--------+
| 10.1.0 4)| N/S | EXP817 | EXP901 | EXP920 | 4)
|
| 10.2.0 4)| Not Supported | EXP920 | 4)
|

+-----------+--------+--------+--------+--------+--------+--------+--------+
| 11.1.0 4)| Not Supported | EXP920 | 4)
|

+-----------+--------+--------+--------+--------+--------+--------+--------+

"Christoph Schwerdtfeger" <cstealth_at_gmx.de> wrote in message news:f65b7dea-a389-4bac-a89f-bd96a8a8286a_at_m44g2000hsc.googlegroups.com...

> Hi list,
>
> we have some 11g and 9i servers and I want to transfer data from an
> 11g to a 9i one.
>
> Using the exp from 11g naturally fails, because the imp of 9i can't
> read the dmp format. Using the imp utility from 9i also fails because
> I get a segmentation fault (no message on the command line, but a
> Windows window telling me that exp.exe encountered an error.
>
> Using the imp utility from 11g on the 9i also fails.
>
> Does anyone has any idea?
>
> Kind regards,
> Christoph 

Received on Thu Mar 20 2008 - 05:13:02 CDT