RE: ORA-00904 invalid column name and export
> Vladimir: There is a known problem with this error after applying patchset 8.1.7.2.1 (The fix is supposed to be re-running catalog and catexp). If you're still having problems, do a full export from the db on Linux to the null device. If you still get the error, then you know for sure it's on the Linux side. Good luck! Barb > -- > From: Vladimir Barac - posao[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Tuesday, July 16, 2002 6: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-8: ORACLE error 904 encountered > ORA-00904: invalid column name > EXP-0: 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara 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).
RE: ORA-00904 invalid column name and export
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 AMTo: Multiple recipients of list ORACLE-LSubject: 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-8: ORACLE error 904 encountered ORA-00904: invalid column name EXP-0: 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).
Re: ORA-00904 invalid column name and export
Title: 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-8: ORACLE error 904 encountered ORA-00904: invalid column name EXP-0: 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).
RE: ORA-00904 invalid column name and export
Title: 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-8: ORACLE error 904 encountered ORA-00904: invalid column name EXP-0: 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).
RE: ORA-00904 invalid column name and export
Vladimir, you probably just need to rerun your catexp.sql file on the source database. Regards, Mike -Original Message- Sent: 16 July 2002 13:08 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-8: ORACLE error 904 encountered ORA-00904: invalid column name EXP-0: 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). This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike 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).