RE: ORA-00904 invalid column name and export

[Richard Huntley]

Title: RE: ORA-00904 invalid column name and export

Have you tried the earlier suggestion that I missed (that should do it)?  That is to rerun catexp.sql on the source DB.  Also, if you have access to Metalink check out the following article:   132904.1 Compatibility Matrix for Export & Import Between Different Oracle Versions   -----Original Message----- From: Vladimir Barac - posao [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 9:48 AM To: Multiple recipients of list ORACLE-L Subject: Re: ORA-00904 invalid column name and export 1. No enough space for exports...   2. All exports are on some large drive (linux box) from where exports go to the tape...   3. No f&!$^% decent shell scripting available on NT... ----- Original Message ----- From: Richard Huntley To: Multiple recipients of list ORACLE-L Sent: Tuesday, July 16, 2002 3:13 PM Subject: RE: ORA-00904 invalid column name and export Vladimir... I'd suggest starting the export on the target, the 8.1.7.0 installation. HTH, Rich -----Original Message----- From: Vladimir Barac - posao [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 8:08 AM To: Multiple recipients of list ORACLE-L Subject: ORA-00904 invalid column name and export Hi! I'm doing export across network. Export is started on Linux server containing 8.1.7.2 enterprise edition install. Target db is 8.1.7.0 enterprise edition residing on WinNT. This is what I get at the end of export log . exporting job queues EXP-00008: ORACLE error 904 encountered ORA-00904: invalid column name EXP-00000: Export terminated unsuccessfully What the hell is going on? Is there a way to avoid this? If there is no way, anyway I would like to know what is going on... Thanks, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao   INET: [EMAIL PROTECTED] Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing).