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" <adam.donahue_at_hcmny.com> 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.
> > dwilliams_at_lifetouch.com
> >
> > -----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: adam.donahue_at_hcmny.com
> >
> > 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: ListGuru_at_fatcity.com (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: JACK_at_QUANTSYSTEMS.NL
> >
> > 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: ListGuru_at_fatcity.com (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: adam.donahue_at_hcmny.com
> >
> > 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: ListGuru_at_fatcity.com (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: DWILLIAMS_at_LIFETOUCH.COM
> >
> > 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: ListGuru_at_fatcity.com (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 (srcdco_at_rit.edu)
> (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: srcdco_at_ritvax.rit.edu
>
> 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: ListGuru_at_fatcity.com (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: oraracdba_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Fri Dec 06 2002 - 18:29:03 CST
