Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to copy or export data from 8.0.5 to 7.3.2 server?

Re: How to copy or export data from 8.0.5 to 7.3.2 server?

From: Reid Lai <reidlai_at_netvigator.com>
Date: Tue, 11 Sep 2001 16:16:41 +0800
Message-ID: <3B9DC869.B361F6BF@netvigator.com>


Marky,

Sybrand only mentioned "desupported" version. Oracle has announce desupport of Oracle7.x for a long time.

Marky Mark wrote:

> What? You mean everyone isn't still running 7.3.2? LOL We're
> upgrading customers from old product versions and some are actually
> still running 7.3.2 and 8.0.5. You'd sell your stocks if I mentioned
> what large companies are still doing this. Save's a buck you know.
> LOL
>
> Um, OK, so by "connect" you mean ??? Is this documented somewhere?
>
> Thanks,
> Mark
>
> On Tue, 11 Sep 2001 06:31:29 +0200, "Sybrand Bakker"
> <postbus_at_sybrandb.demon.nl> wrote:
>
> >
> >"Marky Mark" <DontSpamMe_at_Nospam.org> wrote in message
> >news:581rptgfhgq5q060uidesjmssrbaubuueg_at_4ax.com...
> >> I have an 8.0.5(.2.1) server that I'd like to export a schema from
> >> and import it into a 7.3.2(.2.0) server. As far as I know, I can't
> >> just use the 8.0.5 export as the 7.3.2 import won't understand it.
> >>
> >> The schema is about 500 MB of data, so I'm looking for some
> >> reliable way to "reverse" migrate the data.
> >>
> >> Is there a way to do this?
> >>
> >> Thanks,
> >> Mark
> >>
> >>
> >
> >First question is of course why you want to export data from a desupported
> >version to an even more desupported version.
> >You need to run catexp7.sql in the rdbms\admin directory connected as
> >internal on the 8.0.5 database. Then you need to connect the exp from the
> >version 7.3.2 database to the 8.0.5 database.
> >
> >Regards,
> >
> >Sybrand Bakker, Senior Oracle DBA
> >
> >
Received on Tue Sep 11 2001 - 03:16:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US