Re: Closing a data base link
From: Jusung Yang <JusungYang_at_yahoo.com>
Date: 1 Jul 2003 11:37:16 -0700
Message-ID: <130ba93a.0307011037.52e1c9eb_at_posting.google.com>
Date: 1 Jul 2003 11:37:16 -0700
Message-ID: <130ba93a.0307011037.52e1c9eb_at_posting.google.com>
"Peter Shankey" <shankeyp_at_NOSPAM.comcast.net> wrote in message news:<zcWcnSmS8e4_D5yiXTWJig_at_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