Re: Error during EXP on one instance

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 11 Sep 2001 21:05:55 +0200
Message-ID: <tpsoc44ghfj05c@news.demon.nl>

"Davide Bianchi" <davidebianchi_at_davidebianchi.net> wrote in message news:9nkrkc$7rg2i$1_at_ID-18487.news.dfncis.de...
> I have two, supposedly identical, instances of Oracle 8.1.7.
> On one instance an EXP command end with error during
> 'exporting synonyms' with
>
> ora-00904: invalid column name
>
> Synonyms can be created/removed whatever on the instance.
>
> What can be the problem ?
> Any idea ?
>
> Davide
>
>
>

You forgot to run %ORACLE_HOME%|$ORACLE_HOME/rdbms/admin/catexp.sql connected as internal.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Tue Sep 11 2001 - 14:05:55 CDT