I posted the original post.
alter database rename global_name to new_global_name;
After this you can create links between the two databases
while using global_name=true.
I learned the trick while building advance replication.
Yechiel Adar
Mehish
- Original Message -
To: Multiple
Yechiel - Thanks for this again. Sorry I couldn't recall who posted it.
Sorry Jared. I haven't had a chance to try it, but like many DBAs, I have
been nailed so many times by global_names that this seemed to be a really
clever way around problems.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
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
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
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:
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.
Is it possible to change the global name for one of them?
-Original Message-
Sent: Friday, December 06, 2002 3:34 PM
To: Multiple recipients of list ORACLE-L
Adam - Someone posted a better hidden? parameter awhile back. Jared, was
that you?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
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
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 =
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
Umm I dunno. Don't recall it.
Jared
On Friday 06 December 2002 12:33, 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,
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
That is exactly what I was looking for. Thanks.
Adam
-Original Message-
Sent: Friday, December 06, 2002 7:29 PM
To: Multiple recipients of list ORACLE-L
Adam, If you need keep the global_name the Create the
database link with @ symbol.
The online documentation
13 matches
Mail list logo
