Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> 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 :-)Received on Fri Nov 21 1997 - 00:00:00 CST
![]() |
![]() |