468,556 Members | 2,410 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,556 developers. It's quick & easy.

Closing a data base link

Assuming I have a db link that an application uses once in a great while.
How can it be coded so that the link is close when not in use and only
openned when it is needed?

Thanks
Jul 19 '05 #1
2 3600
"Peter Shankey" <sh******@NOSPAM.comcast.net> wrote in message news:<zc********************@comcast.com>...
Assuming I have a db link that an application uses once in a great while.
How can it be coded so that the link is close when not in use and only
openned when it is needed?

Thanks


If you don't plan to use the db link for a while during the session,
you can explicitly close it with "alter session close database link
....".
- Jusung Yang
Jul 19 '05 #2
"Peter Shankey" <sh******@NOSPAM.comcast.net> wrote in message news:<zc********************@comcast.com>...
Assuming I have a db link that an application uses once in a great while.
How can it be coded so that the link is close when not in use and only
openned when it is needed?

Thanks


Write a short create and drop/alter script.
Run to create the db link
Run to drop/alter db link

Michael Tubuo Ngong
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Alexander Kervero | last post: by
7 posts views Thread by Martien van Wanrooij | last post: by
19 posts views Thread by zacks | last post: by
2 posts views Thread by Peter Shankey | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.