Re: ORacle error

Alex penkrat wrote:
>
> We have a view on an oracle server that references a table through a
> synonym that is on a remote server. the synonym is private for the
> schema owner the view is located in. If I am not hte schema owner i get
> this error message each time and the query never completes. Does anyone
> have any ideas.
> ***********************************************************************************************
> Message 4052: ORA-04052: error occurred when looking up remote object
> SATURN.SPRIDEN_at_TEST.WORLD
> ORA-00604: error occurred at recursive SQL level 1
> ORA-02019: connection description for remote database not found
> ************************************************************************************************
>
> Alex Penkrat
> Consultant
> Waterfield Technology Group
> Apenkrat_at_wtgi.com

Hi,

the database link the schema owner uses to acces the remote table must be public. The synonym must be public to be accessed by everyone.

-- 
Regards

Matthias Gresz    :-)