| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Global Names
alter database rename global_name to whatever;
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of R J Zijlstra
Sent: Monday, July 18, 2005 11:30 PM
To: oracle-l_at_freelists.org
Subject: Global Names
Oracle version 8.1.7
We bought an appl from some other firm.
They had a procedure for making a back-up: copy all dbf files, throw away
ctl files etc etc.
This works, but the problem is, that on any db instance we have ( prod,
test, dev etc) we have the same name for global_name ( select global_name
from global_name). ( And that name is the name of the original inst from the
firm that made the original appl)
This give a nice problem: any db link we create gives a 'circular reference'
error.
Because I'm a developer and there is no DBA in the house (no money; public
healthcare...), I do not know how to handle this.
We now back up by a job that does a hot-backup at night, but still the same
global_name.
Is there any way to change this name?
Thanks,
Rob
--
http://www.freelists.org/webpage/oracle-l
This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 19 2005 - 09:16:33 CDT
 |
 |