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

Thread: Global_names

  1. #1
    Join Date
    Oct 2003
    Posts
    27

    Global_names

    what is the implication of setting GLOBAL_NAMES equal to TRUE?

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Jack,

    Pick any version of oracle documentation and type in global_names in the search engine, you know what it is in 5 min.

    It takes much less than what it takes back and forth posting threads with clarifications. beleive me... I did the same and doing ctrl+c, ctrl+v.

    When you set the initialization parameter GLOBAL_NAMES to TRUE, Oracle ensures that the name of the database link is the same as the global database name of the remote database. For example, if the global database name for HQ is HQ.ACME.COM, and GLOBAL_NAMES is TRUE, then the link name must be called HQ.ACME.COM. Note that Oracle checks the domain part of the global database name as stored in the data dictionary, not the DB_DOMAIN setting in the init.ora file (see Oracle8i Distributed Database Systems).

    If you set the initialization parameter GLOBAL_NAMES to FALSE, you are not required to use global naming. You can then name the database link whatever you want. For example, you can name a database link to HQ.ACME.COM as FOO.
    Reddy,Sam

  3. #3
    Join Date
    Oct 2003
    Posts
    27
    That is a good advice.

    I searched Oracle's documentation Database Administratorís Guide and I have found no mention of setting global_name to TRUE or FALSE. Looks like you can only set it to a name.

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    If you have OTN account use tahiti.oracle.com to get to oracle docs search engine
    Reddy,Sam

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