From: "Niall Litchfield" Newsgroups: comp.databases.oracle.server References: <9fl8gh$jse$1@news.eunet.cz> Subject: Re: Export problem Date: Wed, 6 Jun 2001 15:47:47 +0100 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 Lines: 31 Message-ID: <3b1e429b$0$15026$ed9e5944@reading.news.pipex.net> NNTP-Posting-Host: host9.audit-commission.gov.uk X-Trace: 991838875 reading.news.pipex.net 15026 193.128.236.219 X-Complaints-To: abuse@uk.uu.net There is a coincidence. I had just this issue today on an 8.1.5 database. There is a script $ORACLE_HOME\javavm\install\initdbj.sql which needs running. Having said that when I applied this fix I found I needed to rerun $ORACLE_HOME\javavm\install\initjvm.sql first. To their credit Oracle support responded with the correct answer to this on an iTar in about 30 minutes. I was most impressed. -- Niall Litchfield Oracle DBA Audit Commission UK "ales voderka" wrote in message news:9fl8gh$jse$1@news.eunet.cz... > 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 > >