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 -> Can't export anymore

Can't export anymore

From: Catherine Madsen <cathyd_at_cchem.berkeley.edu>
Date: Tue, 28 Nov 2000 16:51:14 -0800
Message-ID: <3A245302.FBB0B20E@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 - 18:51:14 CST

Original text of this message

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