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

I am trying to export data from 8.1.7.4.1 server with patch 12 on Win 2K, using a SQL*NET connection via 8.1.5.0 server on NT4 SP6.

I have run the 8.1.5 catexp into the 8.1.7 system, as sys, but I keep getting exp-00008 and ora-01406 when I export via the 8.1.5 server.

We need to support the 8.1.5 machine. What else should I be trying to get this data across ?

Steve Hayes, DBA

"Sybrand Bakker" <sybrandb_at_hccnet.nl> wrote in message news:5q2dg05gop0uqhi3papjo0jsbfsqd6jivt_at_4ax.com...
> On Tue, 27 Jul 2004 16:16:33 +0200, "dead"
> <OVOIZBACI-vlasic_at_vodatel.net> wrote:
>
> >How to export from a higher Oracle version (10) and import into a lower
> >Oracle version (9)
> >
>
> Use the lower version export against the higher version database.
> Be sure to have created the v9 export views in the 10g database.
> usually they are called $ORACLE_HOME/rdbms/admin/catexp<version>.sql
> They must be run using SYS as SYSDBA
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Fri Sep 03 2004 - 05:33:27 CDT