Re: Export error from 8.1.6 using 8.1.7 binaries

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 14 Sep 2001 21:34:00 +0200
Message-ID: <tq4nnksbrhob62@news.demon.nl>

"Jarrett A. Bailey" <jarrettabailey_at_austin.rr.com> wrote in message news:0yso7.260820$g_3.57130529_at_typhoon.austin.rr.com...
> I have an oracle 8.1.6 database on a server that I am trying to take an
> export from using an installation of oracle 8.1.7 on my local box. I am
> getting the following errors for each table that the process is trying to
> export:
>
> EXP-00008: ORACLE error 904 encountered
> ORA-00904: invalid column name
>
> thank you in advance for your help.
>
> JB
>
>

This is not going to work. Oracle updates the export datadictionary views with every new release. Evidently, select statements compatible with 8.1.7 have been hardcoded in the 8.1.7 executable. I would just forget about it and install the 8.1.6 executables. The term 'downwards-compatible' means you can use lower version software on a higher version database, NOT the other way around.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Fri Sep 14 2001 - 14:34:00 CDT