RE: ORA-00904 invalid column name and export

From: Richard Huntley <rhuntley_at_mindleaders.com>
Date: Tue, 16 Jul 2002 06:08:22 -0800
Message-ID: <F001.00499024.20020716060822@fatcity.com>

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-----
Sent: Tuesday, July 16, 2002 9:48 AM
To: Multiple recipients of list ORACLE-L

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 ----- To: Multiple recipients of list ORACLE-L <mailto:ORACLE-L_at_fatcity.com> Sent: Tuesday, July 16, 2002 3:13 PM

Vladimir...

I'd suggest starting the export on the target, the 8.1.7.0 installation.

HTH,
Rich

-----Original Message-----
<mailto:vladob_at_aster.si> ]
Sent: Tuesday, July 16, 2002 8:08 AM
To: Multiple recipients of list ORACLE-L

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 <http://www.orafaq.com>
--

Author: Vladimir Barac - posao
  INET: vladob_at_aster.si

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: ListGuru_at_fatcity.com (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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Richard Huntley
  INET: rhuntley_at_mindleaders.com

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: ListGuru_at_fatcity.com (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). Received on Tue Jul 16 2002 - 09:08:22 CDT