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 -> Export Error during 817 to 805 table export

Export Error during 817 to 805 table export

From: DOKNIK <dominiqs_at_o2.co.uk>
Date: Thu, 15 May 2003 16:50:23 +0100
Message-ID: <1053013304.723893@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 Received on Thu May 15 2003 - 10:50:23 CDT

Original text of this message

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