Re: Export from EXP80 on a v7.x database

Dennis Richter wrote:

> I am trying to do an export using EXP80.EXE against a version 7.3 database.
> I get an error saying the proper export views are not built. My questions
> are:
>
> 1. Is EXP80 backwards compatible?
>
> 2. Do I need to run script files from my Oracle8 instance against my Oracle7
> instance to built the required views? If so, what script is necessary?
>
> 3. If I can run EXP80 against the v7.3 database, can I then run IMP73.EXE
> against the export file?

1. Exp and Imp are not generally backwards compatible (especially across major releases)
2. I would advise strongly against doing this (even if you could find a script that would run).
3. You shouldn't be able to run EXP80 against the 7.3 database.

It sounds to me as if you should be running exp73 against the 7.3 database and then running imp80 on the resulting dmp file to import the data into the 8.0 database. This is recommended alternative to the migration tool for migrating v7.3 to v8.0 databases.

Regards,

Ian Cary Received on Thu Nov 20 1997 - 00:00:00 CST