Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Remote database
Hillar Vetik wrote:
> Hello,
> how to check remote datatabase is up or down,
> link exist & if remote database is up all work fine,
> but if remote database is down i have big timeout &
> some meory problems
> Hill
I test them with the following code:
BEGIN
SELECT table_name
INTO i
FROM all_tables_at_remote_database
WHERE rownum = 1;
EXCEPTION
WHEN OTHERS THEN
RAISE ...
END;
Daniel Morgan
Received on Tue Feb 11 2003 - 10:48:02 CST