From oracle-l-bounce@freelists.org Wed Jul 7 12:49:14 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i67HmnV14310 for ; Wed, 7 Jul 2004 12:48:59 -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 i67Hmd614277 for ; Wed, 7 Jul 2004 12:48:49 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7B1BE72C196; Wed, 7 Jul 2004 12:29:09 -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 07909-17; Wed, 7 Jul 2004 12:29:09 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8533E72C6EC; Wed, 7 Jul 2004 12:29:08 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 07 Jul 2004 12:27:40 -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 3BE1172C10B for ; Wed, 7 Jul 2004 12:27:39 -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 07049-36 for ; Wed, 7 Jul 2004 12:27:39 -0500 (EST) Received: from thing2.hypercom.com (cipher.hypercom.com [208.248.82.254]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0026772C4B9 for ; Wed, 7 Jul 2004 12:27:37 -0500 (EST) Received: from Azphxn01.hypercom.com (azphxn01.hypercom.com [10.0.2.70]) by thing2.hypercom.com (8.12.11/8.12.11) with ESMTP id i67HpPfT013049 for ; Wed, 7 Jul 2004 10:51:25 -0700 (MST) In-Reply-To: <20040707174707.60048.qmail@web52108.mail.yahoo.com> Subject: Re: phantom dblink To: oracle-l@freelists.org X-Mailer: Lotus Notes Release 6.5.1 January 21, 2004 Message-ID: From: Ron Thomas Date: Wed, 7 Jul 2004 10:47:10 -0700 X-MIMETrack: Serialize by Router on AZPHXN01/Hypercom/US(Release 6.5.1|January 21, 2004) at 07/07/2004 10:47:14 AM MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 4575 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rthomas@hypercom.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Did you remember to alter database rename global_name to DEV ; Ron Thomas Hypercom, Inc rthomas@hypercom.com "To really screw up Linux you have to work at it...To really screw up Windows, you have to work ON it..." orcl9ps8dba@yahoo.com Sent by: oracle-l-bounce@freelists.o To rg oracle-l@freelists.org cc 07/07/04 10:47 AM Subject phantom dblink Please respond to oracle-l@freelists.org 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 -----------------------------------------------------------------