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.
[EMAIL
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 recipie
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
http://download-west.o
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
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-
> Se
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
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 =
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 post
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.
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.
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: Multip
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 b
12 matches
Mail list logo
