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: database link

Re: database link

From: stephen O'D <stephen.odonnell_at_gmail.com>
Date: 9 Nov 2005 01:42:36 -0800
Message-ID: <1131529356.340561.323010@z14g2000cwz.googlegroups.com>

niraj.kumar.ait_at_gmail.com wrote:
> How to check whether my database link is working or not through any sql
> query.
>
> TIA
> Niraj

As HansF says just select sysdate from dual on the remote database. If you don't get an error then the link is alive. Received on Wed Nov 09 2005 - 03:42:36 CST

This message: [ Message body ]
Next message: Rauf Sarwar: "Re: How do I script object creation?"
Previous message: bharath: "Oracle DBA professionals needed for CMMi Level 5"
In reply to: niraj.kumar.ait_at_gmail.com: "database link"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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