Closing a data base link

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Peter Shankey
    #1

    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


    Tags: None
    • Jusung Yang
      #2
      Re: Closing a data base link

      "Peter Shankey" <shankeyp@NOSPA M.comcast.netwr ote in message news:<zcWcnSmS8 e4_D5yiXTWJig@c omcast.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

        Comment

        • michael ngong
          #3
          Re: Closing a data base link

          "Peter Shankey" <shankeyp@NOSPA M.comcast.netwr ote in message news:<zcWcnSmS8 e4_D5yiXTWJig@c omcast.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

            Comment

            Previous template Next
            Working...