RE: RE: GLOBAL_NAME change

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 21 Jul 2004 15:47:32 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00A77@EXCHMN3>

And then it only applies to the "other" database. Boy that took me awhile to get through my head. In my case, I'm wanting to change the GLOBAL_NAMES=TRUE on database A. To do that I need to change the GLOBAL_NAME value on the database it is linking to. That database will continue to have GLOBAL_NAMES=FALSE. I need to ensure the database links on that other database are not affected. From my tests, they aren't.

Dennis Williams
DBA
Lifetouch, Inc.

"We all want progress, but if you're on the wrong road, progress means doing an about-turn and walking back to the right road; in that case, the man who turns back soonest is the most progressive."
-- C.S. Lewis

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Goulet, Dick Sent: Wednesday, July 21, 2004 3:44 PM
To: oracle-l_at_freelists.org
Subject: RE: RE: GLOBAL_NAME change

Only if you have Global_names=3DTrue in your init.ora or spfile.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----

From: solbeach_at_cox.net [mailto:solbeach_at_cox.net] Sent: Wednesday, July 21, 2004 4:33 PM
To: oracle-l_at_freelists.org
Subject: Re: RE: GLOBAL_NAME change

It has been my experience that DB_LINKs "break" after changing=20 the GLOBAL_NAME.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Wed Jul 21 2004 - 15:49:23 CDT