Re: Export Error during 817 to 805 table export

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Fri, 16 May 2003 09:19:37 +1000
Message-ID: <35Vwa.35103$1s1.509696@newsfeeds.bigpond.com>

"DOKNIK" <dominiqs_at_o2.co.uk> wrote in message news:1053013304.723893_at_ernani.logica.co.uk... All,
I have used an Oracle 8.0.5 version of EXP ie( /u01/app/oracle/product/8.0.5/bin/exp) to do a table export from a database on Oracle 8.1.7 to an Oracle (8.0.5) database but during the export i get the errors below.

About to export specified tables via Conventional Path ... . . exporting table BV_SHOP_LARGE_CONTENT EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
Export terminated successfully with warnings.

Using suggesstions from Metalink i tried the following

1.I run catexp.sql as SYS
2.run initjvmaux.sql
3.run rmjvm.sql

These were the steps suggested at metalink but still doesnt work. I am running this on Solaris 2.6

Any ideas will be welcome.Thanks

---

First idea: don't post in HTML, because a lot of regulars here don't use Outlook Express, and can only see plain text messages.

Second. Do a desc of BV_SHOP_LARGE_CONTENT, and post the results here.

Regards
HJR Received on Thu May 15 2003 - 18:19:37 CDT