Re: Oracle 8 to Oracle 7.x Export - Import

Darren:

We are wish to try this experiment of taking the Oracle 8 export file and imprting it into an Oracle 7.1 DB. We are running OpenVMS 6.2 with Oracle 7.1 on an Alpha 8400 and Oracle 8.0 on Sun with DEC Unix.

I need clarification on :

>> basically run catexp7.sql

Is the catexp7.sql file located on the computer running Oracle 8 or the Computer running Oracle 7 ?

Do you execute this file after the 7 export takes place ?

>>and then run O7 Export against the O8 database.

How do you "run the O7 Export against the 08 database ? How does the 08 export data get into the 07 DB ?

What are the exact steps ?

Darren Mallette wrote:

> Stan Novinsky <stan_novinsky_at_jhuapl.edu> wrote:
>
> >I have a few questions related to the new release of Oracle:
> >
> >Can Oracle:
> > 7.1
> > 7.2
> > 7.3
> >export files be imprted into an Oracle 8 DB ?
> >
>
> Yes. I found a quirk though -- if you have CHAR fields, they'll get
> converted to VARCHAR2 by IMP8.
>
> >Can Oracle 8 export files be imported into an Oracle:
> > 7.1 DB
> > 7.2 DB
> > 7.3 DB
>
> Yes. See the documentation for details, but you basically run
> catexp7.sql and then run O7 Export against the O8 database.
>
> -Darren
>
> Darren Mallette
> www.geocities.com/HotSprings/7490
Received on Mon Sep 08 1997 - 00:00:00 CDT