Re: Export problem

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..."