Re: Can't export anymore

run %ORACLE_HOME%\rdbms\admin\catexp.sql, connected as internal or any other user with SYSDBA privs.

Hth,

Sybrand Bakker, Oracle DBA

"Catherine Madsen" <cathyd_at_cchem.berkeley.edu> wrote in message news:3A245302.FBB0B20E_at_cchem.berkeley.edu...
> Hello everybody,
>
> I hope you can help me. We are using Oracle8i, release 8.1.5 on a NT
> server. We had some hardware problems two months ago and got new hard
> drives. I exported the database (no error messages), recreated it and
> imported it. Now, I can't export anymore. When I try to export any
> schema or the entire database, the export goes on normally until it
> reaches the synonyms then:
> exporting synonyms...
> EXP-0008: Oracle error 904 encountered
> ORA-00904: Invalid column name
> EXP-00000: Export terminated unsuccessfully
>
> However, I can export individual tables.
> We have not created any synonyms and I don't know how to find which
> column could be the problem. The database had been migrated from Oracle
> 7.3.4 earlier this year and I'm wondering if it has something to do with
> it.
> Any help would be greatly appreciated. Thanks,
>
> Catherine Madsen
>
Received on Tue Nov 28 2000 - 23:49:21 CST