Re: Import 11g dump in 9i

From: <fitzjarrell_at_cox.net>
Date: Thu, 20 Mar 2008 08:42:16 -0700 (PDT)
Message-ID: <9cae3015-40cc-4778-93ca-b5d4f7a316b6@d45g2000hsc.googlegroups.com>


On Mar 20, 10:06 am, Christoph Schwerdtfeger <cstea..._at_gmx.de> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

You haven't patched your 9.2 database to 9.2.0.8? Or haven't you applied the 9.2.0.8 patchset to the client installation? It might be worth the effort to do so.

David Fitzjarrell Received on Thu Mar 20 2008 - 10:42:16 CDT

Original text of this message