Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export problem
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" <ales.voderka_at_e-bs.cz> wrote in message news:9fl8gh$jse$1_at_news.eunet.cz...Received on Wed Jun 06 2001 - 09:47:47 CDT
> 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
>
>