From: Connor McDonald Newsgroups: comp.databases.oracle.server Subject: Re: Export problem Date: Wed, 06 Jun 2001 18:56:06 +0100 Organization: Budget Internet Lines: 27 Message-ID: <3B1E6EB6.784C@yahoo.com> References: <9fl8gh$jse$1@news.eunet.cz> NNTP-Posting-Host: 62.172.35.94 Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: news.chatlink.com 991850637 14359 62.172.35.94 (6 Jun 2001 18:03:57 GMT) X-Complaints-To: abuse@chatlink.com NNTP-Posting-Date: 6 Jun 2001 18:03:57 GMT X-Mailer: Mozilla 3.01 (Win95; I) ales voderka wrote: > > Hi, > we have oracle 8.1.6SS server and now when we try to export using exp > utility it ends with an error ORA-00904 when exporting synonyms. I tried to > find invalid synonyms, but I could not find any method how to get it. Using > other ways I realized that we have about 180 invalid java classes on which > are public synonyms. > This problem occurs even when we do try to export schema without any > synonyms. > > Thanks in advance Ales Try re-running catexp to ensure that the views are correct. If that doesn't work, have a look at: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=1017276.102 hth connor -- ============================== Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..."