Re: Exporting Oracle8 database from 8i Client

Perhaps try running catexp.sql from /oracle805/rdbms/admin (or whichever way appropriate)? This will hopefully create the views needed for export to work.

However, I haven't tested this - so maybe someone more knowledgeable will 'critique' the above before you do it.

The best idea might be to run the 805 export utility if available...

"hieraklion" <hieraklion_at_spray.fr> wrote in message news:3ACC96BE.FD4291D_at_spray.fr...
> "Bonjour" from Paris
>
> From Oracle documentation :
>
> Using a Higher Version of Export
>
> Attempting to use a higher version of Export with an earlier Oracle
 database
> server often produces the following error:
>
> EXP-37: Database export views not compatible with Export utility
>
> EXP-0: Export terminated unsuccessfully
>
>
> The error occurs because views that the higher version of Export expects
 are not
> present. To avoid this problem, use the version of the Export
> utility that matches the Oracle database server.
>
>
> "Au revoir" from Paris
> Hieraklion
>
> Anurag Minocha a écrit :
>
> > Hi,
> > I have a Oracle8i(8.1.7) enterpise edition installed on a windows 2000
> > machine and am connecting to a Oracle8.0.5 database using the net8
> > configuration.
> > I am unable to export the Oracle8 database. It says
> >
> > C:\ADMINI~1\Backup>exp.EXE system/manager_at_panda full=y file=
 sid6\dlysid6
> > .dmp consistent=y
> >
> > Export: Release 8.1.7.0.0 - Production on Thu Apr 5 09:46:19 2001
> >
> > (c) Copyright 2000 Oracle Corporation. All rights reserved.
> >
> > Connected to: Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
> > With the Objects option
> > PL/SQL Release 8.0.5.0.0 - Production
> > EXP-00037: Export views not compatible with database version
> > EXP-00000: Export terminated unsuccessfully
> >
> > Is there some way I can do the exports and assuming to do it, will I be
 able
> > to import if needed to a Oracle8 database.
> >
> > Thanks
> > Anurag
> >
> > --
> > Posted from jshemail.herold.com [63.105.8.14]
> > via Mailgate.ORG Server - http://www.Mailgate.ORG
>
Received on Fri Apr 06 2001 - 08:14:58 CDT