Re: Check invalid synonym with dblink

KENY wrote:

> Hello,
>
> I'm looking for a script or method to check the validity of synonyms
> which point on an invalidate dblink object.
>
> Thanks in advance.
> Cordially.

Consider the following:

SQL> desc dba_synonyms

How hard did you try to find the answer before asking the question? ;-)

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)