Global_names True/False?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Global_names True/False?

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Posts
    63
    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
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    If you are using the global names, then your database link name has to be the same as the db instance name.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    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