Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Export error from 8.1.6 using 8.1.7 binaries

Re: Export error from 8.1.6 using 8.1.7 binaries

From: Ron Reidy <ron_at_indra.com>
Date: Sun, 16 Sep 2001 16:59:59 -0600
Message-ID: <3BA52EEF.64109393@indra.com>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US