Re: Import/Export from 8 to 7

From: James Hanway <hanwayj_at_dfo-mpo.gc.ca>
Date: Thu, 28 Oct 1999 13:59:51 GMT
Message-ID: <381856F3.55BCF027@dfo-mpo.gc.ca>

What about establishing a DB LINK between the two databases and copy the tables via SQL*NET?

Riccardo Ferrari wrote:

> I have to export some tables from an Oracle 8.0.5 and import them in an
> Oracle 7.3.2 DB.
> I thought to do the export from the Oracle7 server (using Oracle7 export
> routine) connecting to the Oracle8 DB via SQL-NET. But doing the export
> operation I get the following error message:
> EXP0024: Export views not installed, please notify your DBA.
> I know the export and import utilities need some system views to run (those
> generated by catexp.sql) and I've also ran the script without result. I
> think the problem is related to the different Oracle versions.
> Could anyone help me?
> Thanks in advance
> Riccardo
Received on Thu Oct 28 1999 - 08:59:51 CDT