Re: How to export from a higher Oracle version and import into a lower Oracle version

dead wrote:
> I start catexp.sql with SYS
> and after that I copy all files from bin directori of Oracle 9i into server
> with Oracle10i and try to start exp.exe from that Oracle9i and I have next
> message :
>
> Message 206 not found; No message file for product=RDBMS, facility=EXP:
> Release
> 9.2.0.1.0 - Production on Thu Jul 29 14:22:30 2004
> Copyright (c) 1982, 2002, Oracl
> Invalid format of Export utility name
> Verify that ORACLE_HOME is properly set
> Export terminated unsuccessfully
> EXP-00000: Message 0 not found; No message file for product=RDBMS,
> facility=EXP
>
>

Well, that was not exactly what you have been told to do, was it?

* Why did you copy some binaries from one server to the other?
* Is there no network between the two?
* If there is a network, why copy binaries instead of properly configuring

   SQL*Net and run the export from the 9i Server? * If there is no network, is it really worth the effort to copy (nonfunctional

   as you know no) binaries to an removable storage instead of performing    a userdefined 9i Client Installation so that you get a functional 9i setup    on the 10g Server?

There are few ways to get your task wrong, but somehow you managed to hit almost all of them ;-)

Just setup your tnsnames.ora preferrably with netca or netmgr on the 9i Server so that you can connect to the 10g Server with sqlplus. Make sure the export views exist by following Sybrands post. Then use exp on the 9i Server and you're done.

Read Sybrands advice again. Slowly. Try to understand what he says. All you need to do is there.

HTH
Holger Received on Thu Jul 29 2004 - 08:12:05 CDT