By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,321 Members | 1,206 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,321 IT Pros & Developers. It's quick & easy.

Closing a data base link

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
"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

P: n/a
"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.