Re: Error ora-904 and 1003 during export

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 28 Sep 1998 23:44:03 +0200
Message-ID: <36100323.5E807E1F@sybrandb.demon.nl>

This usually means your export dictionary views are outdated. They modify frequently. You need to run $ORACLE_HOME/rdbms/admin/catexp.sql on the server.
Chances are your OEM software is older if it does work at that side.

Hth
Sybrand Bakker, Oracle DBA

Phil Britton wrote:

> Hi,
>
> when I'm doing a user export with exp73 I get the following error
> messages after the message
> .. exporting table TABLE1 n rows exported
> EXP-00008 ORACLE error 904 encountered
> ORA-904: invalid column name
> . . exporting table TABLE2 m rows exported
> EXP-00008 ORACLE error 1003 encountered
> ORA-1003 no statement parsed.
>
> and then it does the same for all subsequent tables.
>
> If I do this using OEM data manager then I don't get the errors.
> anyone seen this one before or gto any ideas,
>
> cheers
>
> Phil
Received on Mon Sep 28 1998 - 16:44:03 CDT