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

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Recently we came upon a situation where it would be best to install a snapshot using a database link to another server at our facility. We have been able to get the database link to work correctly through SQL Plus but only after doing an alter session set global_names= true. Otherwise, we get the ORA-02085 error.

    It seems that if I were to change my init.ora file to set the global_names = false, then I could resolve the error, but I don't know what kind of impact it would have on other scripts I have in place already.

    All of the databases I connect to are local to the facility where I work, so using global names really isn't necessary, but I'd hate to change the global_names parameter and have things fail on me.

    Any words of advice?

  2. #2
    Join Date
    Oct 2000
    Saskatoon, SK, Canada
    If you are using the global names, then your database link name has to be the same as the db instance name.


    Life is a journey, not a destination!

  3. #3
    Join Date
    Nov 2000
    Setting global_names=false should not break anything. If you already have global_names = true, then by setting to false, you tell oracle that you don't care what another database is named when you create a db_link to it. To see what your exposure might be, query dba_db_links to see how many other links you have that might be affected.

    For reference, http://technet.oracle.com/docs/produ...ch155.htm#2946

    PS. I always explicitly set global_names=false...
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.