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." -- //www.freelists.org/webpage/oracle-l
