RE: Global Names
- To: <rmsah@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 19 Jul 2005 08:12:23 -0600
alter database rename global_name to whatever;
-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of R J Zijlstra
Sent: Monday, July 18, 2005 11:30 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
