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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 11 Sep 2001 06:31:29 +0200
Message-ID: <tpr568c51mib13@news.demon.nl>

"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 Mon Sep 10 2001 - 23:31:29 CDT