Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle-l »

Re: DB link testing

orcl

2007-07-23

Replies:

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@(protected)) ||
'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


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.