Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Remote database

Re: Remote database

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Tue, 11 Feb 2003 08:48:02 -0800
Message-ID: <3E492942.7C3352F6@exesolutions.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US