Adam, If you need keep the global_name the Create the database link with "@" symbol.
The online documentation http://download-west.oracle.com/docs/cd/A97630_01/server.920/a96521/ds_admin.htm#13803 gives you some examples. I am not sure if this is what you are looking for but it may help. Scott --- "Donahue, Adam" <[EMAIL PROTECTED]> wrote: > Thanks for the suggestions, all. I knew about these > workarounds, but apparently the answer to my > original question is "no". > > Adam > > -----Original Message----- > Sent: Friday, December 06, 2002 5:39 PM > To: Multiple recipients of list ORACLE-L > > > There is: Alter database rename global_name.... > > Waleed > > -----Original Message----- > Sent: Friday, December 06, 2002 5:14 PM > To: Multiple recipients of list ORACLE-L > > > You can update the global_name by using sqlplus or > svrmgrl (internal or "/ > as > sysdba" or sys): > > update global_name > set global_name = newname; > commit; > > I do this every time I clone a database. If you > don't change it, then the > database links won't work. > > DENNIS WILLIAMS wrote: > > > Adam - Someone posted a better "hidden?" parameter > awhile back. Jared, was > > that you? > > > > Dennis Williams > > DBA, 40%OCP > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > -----Original Message----- > > Sent: Friday, December 06, 2002 11:29 AM > > To: Multiple recipients of list ORACLE-L > > > > I was afraid that'd be the only way. Thanks. > > > > Adam > > > > -----Original Message----- > > Sent: Friday, December 06, 2002 12:05 PM > > To: Multiple recipients of list ORACLE-L > > > > Hi > > > > Set global_names = false in init.ora file and try > again > > > > -----Original Message----- > > Sent: vrijdag 6 december 2002 17:41 > > To: Multiple recipients of list ORACLE-L > > > > Don't ask how we got into this situation, but I > have two instances with > the > > same global_name and need to be able to create a > link between them. Is > this > > doable? > > > > Adam > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Donahue, Adam > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > > San Diego, California -- Mailing list and > web hosting services > > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Jack van Zanen > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > > San Diego, California -- Mailing list and > web hosting services > > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like subscribing). > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Donahue, Adam > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > > San Diego, California -- Mailing list and > web hosting services > > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: DENNIS WILLIAMS > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > > San Diego, California -- Mailing list and > web hosting services > > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like subscribing). > > -- > Scott Canaan ([EMAIL PROTECTED]) > (585) 475-7886 > "Life is like a sewer, what you get out of it > depends on what you put into > it." > - Tom Lehrer. > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Scott Canaan > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > === message truncated === __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
