From oracle-l-bounce@freelists.org Wed Jul 7 13:09:59 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i67I9iI17934 for ; Wed, 7 Jul 2004 13:09:54 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i67I9X617877 for ; Wed, 7 Jul 2004 13:09:43 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F105572CA04; Wed, 7 Jul 2004 12:50:56 -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 11881-72; Wed, 7 Jul 2004 12:50:56 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E67F772CD3D; Wed, 7 Jul 2004 12:50:51 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 07 Jul 2004 12:49:24 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0F62A72C474 for ; Wed, 7 Jul 2004 12:49:24 -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 11881-43 for ; Wed, 7 Jul 2004 12:49:23 -0500 (EST) Received: from mx1.state.vt.us (ns1.state.vt.us [159.105.23.130]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A138872C1D7 for ; Wed, 7 Jul 2004 12:49:23 -0500 (EST) Received: from TAX132 ([159.105.89.132]) by mx1.state.vt.us (Post.Office MTA v3.5.4 release 224 ID# 0-0U10L2S100V35) with SMTP id us for ; Wed, 07 Jul 2004 14:13:12 -0400 From: "Ruth Gramolini" To: Subject: RE: phantom dblink Date: Wed, 7 Jul 2004 14:13:12 -0400 Message-ID: <004901c4644e$109f7990$8459699f@vttaxnet.tax.state.vt.us> MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 In-Reply-To: <20040707174707.60048.qmail@web52108.mail.yahoo.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Importance: Normal X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4580 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rgramolini@tax.state.vt.us Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org If one DB is a clone of another then you have to change the DBID in order for the two DB's to appear separate. Use the DBNEWID utility to change the name and DBID or just the DBID. We had a similar problem with DB links and solved it in this way. HTH, Ruth -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Mike Hennesy Sent: Wednesday, July 07, 2004 1:47 PM To: oracle-l@freelists.org Subject: phantom dblink I routinely refresh my DEV instance with a backup of my PROD instance. After I test recovering PROD on the dev machine I create a new control file and rename the instance to DEV with the following: CREATE CONTROLFILE SET DATABASE "DEV" RESETLOGS ARCHIVELOG Now for the strange part. In DEV there is NOT a dblink for PROD but the query select * from APP_TABLE@PROD ; returns rows. I would expect a ORA-02019 error. The returned rows are actually coming from the DEV instance and not PROD. This isn't the end of the world for me by no means. The instance will be refreshed over the weekend and I told the programmers there isn't a dblink to PROD and to not try. I just thought this was a strange behavior and was wondering if anyone else had come across it. 8.1.7.3 Thanks - Mike --------------------------------- Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------