From oracle-l-bounce@freelists.org Wed Jul 7 12:44:33 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i67HiIB13345 for ; Wed, 7 Jul 2004 12:44:28 -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 i67Hi7613309 for ; Wed, 7 Jul 2004 12:44:17 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3EFBC72CC2B; Wed, 7 Jul 2004 12:24:49 -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 05807-74; Wed, 7 Jul 2004 12:24:49 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 932D072CCB8; Wed, 7 Jul 2004 12:24:48 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 07 Jul 2004 12:23:21 -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 28A6272CA26 for ; Wed, 7 Jul 2004 12:23:20 -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 05421-54 for ; Wed, 7 Jul 2004 12:23:19 -0500 (EST) Received: from web52108.mail.yahoo.com (web52108.mail.yahoo.com [206.190.39.77]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 8E76F72C9FF for ; Wed, 7 Jul 2004 12:23:19 -0500 (EST) Message-ID: <20040707174707.60048.qmail@web52108.mail.yahoo.com> Received: from [137.148.2.12] by web52108.mail.yahoo.com via HTTP; Wed, 07 Jul 2004 10:47:07 PDT Date: Wed, 7 Jul 2004 10:47:07 -0700 (PDT) From: Mike Hennesy Subject: phantom dblink To: oracle-l@freelists.org MIME-Version: 1.0 Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 4573 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: orcl9ps8dba@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at 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 -----------------------------------------------------------------