Re: Import 11g dump in 9i

On 20 Mrz., 11:13, "Jack" <n..._at_INVALIDmail.com> wrote:
> 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
> |
> +-----------+--------+--------+--------+--------+--------+--------+--------+
[...]
> +-----------+--------+--------+--------+--------+--------+--------+--------+
> | 11.1.0 4)| Not Supported | EXP920 | 4)
> |
> +-----------+--------+--------+--------+--------+--------+--------+--------+

According to this matrix 9.2 should work with 11g.

As you can see on the screenshot[1] I'm using version 9.2.0.1.0 to connect to the 11g database - without success.

The screenshot is in German, but I guess you can understand most parts. If not, I'll translate it.

Regards,
Christoph

PS.: Jack, sorry for directly mailing my first answer to you.

[1] http://img139.imageshack.us/my.php?image=oracle11gexpih3.jpg Received on Thu Mar 20 2008 - 10:06:09 CDT