Re: Import/Export from 8 to 7

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Thu, 28 Oct 1999 15:50:45 -0700
Message-ID: <3818D345.2585CBCC@vnl.nl>

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

Install the Oracle7 views in Oracle8 by running catexp7.sql against 8. Then you can use Oracle7 export against oracle8

--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle

Work:                                Home:
----------------------------------   ----------------------------
Inter Access V&L                     Hunzestraat 4
Palatijn 3, 7521 PN Enschede         7555 WB Hengelo
PoBox 545, 7500 AM Enschede          (31)074-2425046

053-4341500 Received on Thu Oct 28 1999 - 17:50:45 CDT