DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: DB Links clean up after refresh

  1. 03-30-2006, 05:25 AM #1
    bang_dba
    bang_dba is offline Senior Member
    Join Date
    Sep 2002
    Posts
    376

    DB Links clean up after refresh

    Hi,

    After database refresh, we are changing the db links in the procedures to point to the corresponding dev databases.

    Is there any easy way to eliminate this tedious process ?
    I guess using synonyms for dblinks would be a easy method, which would reduce lot of work
    ------------------------------------------------------------------------
    The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway
    Reply With Quote Reply With Quote
  2. 03-30-2006, 05:49 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    dont need to change anything, have tns entries for the original databases on the dev servers which point to the dev databases
    Reply With Quote Reply With Quote
  3. 03-30-2006, 08:23 AM #3
    robertbalmer
    robertbalmer is offline Member
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    synonyms on db_link work well.
    Able was I ere I saw Elba
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width