Re: Export error

From: Chris Hamilton <toneczar_at_erols.com>
Date: Thu, 14 May 1998 19:31:33 GMT
Message-ID: <6jfgqr$7f1$2@goo.nwd.usace.army.mil>

In article <6jfc9q$t2u$1_at_nnrp1.dejanews.com>, katoz_at_iname.com wrote:
>We are using Oracle 7.3 on an SGI system. When exporting a table (regardless
>of the table), we receive the following error:
>
>EXP-00008: ORACLE error 904 encountered
>ORA-00904: invalid column name
>EXP-00000: Export terminated unsuccessfully
>
>The import appears to run fine & since this error appears regardless of the
>table exported, it's not an invalid column within the table.
>
>Any ideas?

You need to run the catexp.sql script for your version of the RDBMS. Look in the $ORACLE_HOME/rdbms/admin directory and run it using Server Manager. This script builds / updates various views for the export utility. The views may be out of date with respect to your current software version.

Better still, run the whole suite of files:

cat7301.sql
cat7302.sql
cat7303.sql
catalog.sql
catproc.sql

catalog.sql calls catexp.sql, so that should take care of the export problem and any other potential data dictionary problems. Always run the version-specific upgrade scripts (the first three above) plus the last two anytime you upgrade a database from one version to a higher version.

Chris

Chris Hamilton -- toneczar_at_erols.com
City of Washington Pipe Band
http://www.serve.com/cowpb/chamilton.html Received on Thu May 14 1998 - 14:31:33 CDT