| DB LINK [message #66009] |
Tue, 02 October 2001 04:14  |
Fabio
Messages: 23
Registered: October 2001
|
Junior Member |
|
|
Hello everyone,
How can I check if a db-link is active or not in PL/SQL?
Thanks
Fabio
----------------------------------------------------------------------
|
|
|
|
| Re: DB LINK [message #66013 is a reply to message #66009] |
Thu, 04 October 2001 11:14  |
Carlos Manjarres
Messages: 1
Registered: October 2001
|
Junior Member |
|
|
A quick and dirty method is just a SELECT statement.
select count(*) from REMOTE_TABLE@REMOTE_DATABASE
where REMOTE_DATABASE is pointed by your DB_LINK.
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
