From: "ales voderka" <ales.voderka@e-bs.cz>
Newsgroups: comp.databases.oracle.misc
Subject: Export problem
Date: Wed, 6 Jun 2001 14:43:20 +0200
Organization: KPNQwest Czechia
Lines: 12
Message-ID: <9fl8hl$adf$1@news.eunet.cz>
NNTP-Posting-Host: fw.e-bs.cz
X-Trace: news.eunet.cz 991831413 10671 193.86.194.41 (6 Jun 2001 12:43:33 GMT)
X-Complaints-To: usenet@news.eunet.cz
NNTP-Posting-Date: 6 Jun 2001 12:43:33 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400


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