Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export error from 8.1.6 using 8.1.7 binaries
"Jarrett A. Bailey" wrote:
>
> 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
I had this before. The problem (as described on metalink) is there are
some synonyms that do not have objects behind them. I followed the
procedure outlined in the metalink note, but the problem persisted. I
then exectued catproc.sql and all was well.
-- Ron Reidy Oracle DBA Reidy Consulting, L.L.C.Received on Sun Sep 16 2001 - 17:59:59 CDT