Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: GLOBAL_NAME vs. SERVICE_NAMES

Re: GLOBAL_NAME vs. SERVICE_NAMES

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Mon, 30 Jul 2007 09:19:20 +0200
Message-ID: <46AD90F8.4050906@gmail.com>


hjr.pythian_at_gmail.com schrieb:

>
> GLOBAL_NAMES (it's plural by the way) is simply set to TRUE or FALSE.
> Set it to TRUE and database links you create must have a name in your
> local database that is the same as the name of the remote database
> being linked to. Set it to FALSE, and even if you are creating a link
> to the SALES database, you can call the link 'FREDSLINK'. It is only
> of relevance in a distributed database situation, in other words. Some
> Oracle replication functionality doesn't actually function unless
> GLOBAL_NAMES is TRUE.
>
> Regards
> HJR
> http://www.dizwell.com
>

My impression was rather, the question was not about GLOBAL_NAMES but about GLOBAL_NAME, which is more naturally to compare with SERVICE_NAMES ( both purpose is for network identification of database). To OP: GLOBAL_NAMES is a database property, whereas SERVICE_NAMES is a instance property, i would say , after HJR's explanation there is not much to add, except the link to documentation http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm#sthref338 http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams187.htm#REFRN10194

Best regards

Maxim Received on Mon Jul 30 2007 - 02:19:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US