Hi Patrice, why don't you try to test the link itself
The error message will tell you , for exampleORA-02019
: says wrong conection description, or whatever it is.
x number :=0;
execute immediate( 'select 1 from sys.dual@(protected);
exception when others then
0 not connected 1 connected
On Thu, 10 Feb 2005 16:27:36 -0400, Boivin, Patrice J
> Does anyone have a script that tnspings all db links to produce a list of
> the invalid ones?
> I did one in sqlplus, which hosts to the command line to run tnsping, but
> the output never appears in the spool file.
Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i
8 years of experience in Oracle 7,8i,9i,10g and developer 6i