From oracle-l-bounce@freelists.org Tue Jul 19 09:16:33 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j6JEGWw6016352 for ; Tue, 19 Jul 2005 09:16:32 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j6JEGUIP016342 for ; Tue, 19 Jul 2005 09:16:30 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E22D21D6739; Tue, 19 Jul 2005 09:16:26 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 29546-06; Tue, 19 Jul 2005 09:16:26 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 694D01D6657; Tue, 19 Jul 2005 09:16:26 -0500 (EST) Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: Global Names Date: Tue, 19 Jul 2005 08:12:23 -0600 Message-ID: <17CAB0BF27BCFC47B0E4554A0E2F962B8730D3@fiji.arraybp.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Global Names Thread-Index: AcWMGxtNkXM6E5gOQ0KwquXH+CyxfAABpi0gABJ68PAFrom: "Reidy, Ron" To: , X-OriginalArrivalTime: 19 Jul 2005 14:12:23.0130 (UTC) FILETIME=[E20513A0:01C58C6B] X-archive-position: 22662 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Ron.Reidy@arraybiopharma.com Precedence: normal Reply-To: Ron.Reidy@arraybiopharma.com X-list: oracle-l From: oracle-l-bounce@freelists.org X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.7 required=5.0 tests=AWL,BAYES_00,NO_REAL_NAME autolearn=no version=2.63 alter database rename global_name to whatever; ----------------- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of R J Zijlstra Sent: Monday, July 18, 2005 11:30 PM To: oracle-l@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