DXiang is right, another way is to copy the 8.1.6 'export executable' and to use it. Why use an 9.2 if you have the 8.1.6 ???
----- Original Message -----
From: "Nirmalya Das " <oracledba-ezmlmshield-x68199697.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Subject: Re: export data from v9.2 client connecting to V8.1.6 server
Date: Mon, 30 May 2005 09:51:47 -0700
>
> I think export/import of 9i and 8i are compatible at 8.1.7.4 level.
>
> --On Monday, May 30, 2005 11:58 AM -0400 DXiang
> <oracledba-ezmlmshield-x6509809.[Email address protected] wrote:
>
> > Hey Gurus,
> >
> > I was trying to export data from a V9.2 client connecting to a V8.1.6
> > server and got the follwoing error messages.
> > Export: Release 9.2.0.1.0 - Production on Mon May 30 11:14:33 2005
> >
> > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
> >
> >
> > Connected to: Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
> > With the Partitioning option
> > JServer Release 8.1.6.2.0 - Production
> > EXP-00056: ORACLE error 942 encountered
> > ORA-00942: table or view does not exist
> > EXP-00000: Export terminated unsuccessfully
> >
> > I searched the web, Somecases say I can't export from a high version
> > client. If that's true, does any one have any bypass way to do that?
> >
> > Many thanks in advance.
> >
> >
> > David Xiang
> > Canadian Depository For Securities Ltd.
> > 85 Richmond St. West.
> > Toronto, Ontario
> > M5H 2C9
> > (416) 815-2029
> > email: [Email address protected]
> > <br>
> > The information in this e-mail is confidential, privileged and is subject
> > to copyright. It is intended solely for the addressee(s) named. Access to
> > this e-mail by anyone else is unauthorized. If you are not the intended
> > recipient, any disclosure, copying, distribution or any action taken or
> > omitted to be taken in reliance on it is prohibited and may be unlawful
> > and we ask that you notify us immediately by telephone at (416) 365-8400
> > or reply by e-mail to the sender. When addressed to our participants or
> > other clients, any information contained in this e-mail is subject to the
> > terms and conditions expressed in any applicable agreement governing the
> > use of CDS services.</font><br>
> >
> > <font size="2">Les renseignements contenus dans ce courriel sont
> > confidentiels, privilégiés, soumis aux droits d\'auteur et sont
> > strictement réservés à son destinataire prévu. L\'accès à ce courriel par
> > toute autre personne est non autorisé. Si vous n\'êtes pas le
> > destinataire prévu, toute divulgation, copie, transmission, ou tout autre
> > acte posé ou omis relativement à ce document est interdit et peut être
> > considéré comme illégal et nous vous demandons de nous en aviser
> > immédiatement par téléphone au (514) 848-1010 ou en répondant par
> > courriel à l\'expéditeur. Lorsque ces renseignements s\'adressent à nos
> > adhérents ou à nos autres clients, ils sont soumis aux conditions
> > stipulées dans toute convention régissant l\'utilisation des services de
> > la CDS.</font>
> >
> >
> >
> > --------
> > website: http://www.LazyDBA.com
> > Please don't reply to RTFM questions
> > Oracle documentation is here: http://tahiti.oracle.com
> > To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> > To subscribe: see http://www.lazydba.com
> > By using this list you agree to these
> > terms:http://www.lazydba.com/legal.html
> >
>
>
>
> Thanks with best regards,
>
> Nirmalya Das 510/557-7055 (voice)
> HLN Consulting, LLC. 866/565-0329 (FAX)
> 33666 Slender Ct. [Email address protected]
> Fremont, CA 94555 http://www.hln.com/
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
DEGAND XAVIER
DX SPRL
BRUSSELS, BELGIUM
Oracle LazyDBA home page