Re: DB link testing

Bill I meantt to post this last friday, you probably have someting working by now, but here is what I use, simple but effective ;-)

spool C:\work\test_links\tlink.sql
set feedback on
set echo on
set pagesize 0
set linesize 450
SELECT 'select * from dual@'||db_link||';'|| chr(10) ||
'COMMIT;'||chr(10)||
'ALTER SESSION CLOSE DATABASE LINK '||db_link||';'
FROM dba_db_links
order by 1;
spool off
@C:\work\test_links\tlink.sql

hth
Bob

-- 
"Oracle error messages being what they are, do not
highlight the correct cause of fault, but will identify
some other error located close to where the real fault lies."

--
http://www.freelists.org/webpage/oracle-l