Re: phantom dblink

From: Ron Thomas <rthomas_at_hypercom.com>
Date: Wed, 7 Jul 2004 10:47:10 -0700
Message-ID: <OF9D39DC6E.00E9EDA1-ON07256ECA.0061AA62-07256ECA.006217B0@hypercom.com>

Did you remember to

alter database rename global_name to DEV ;

Ron Thomas
Hypercom, Inc
rthomas_at_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_at_yahoo.com                                                                  
             Sent by:                                                                               
             oracle-l-bounce_at_freelists.o                                                         To 
             rg                                  oracle-l_at_freelists.org                             
                                                                                                 cc 
                                                                                                    
             07/07/04 10:47 AM                                                              Subject 
                                                 phantom dblink                                     
                                                                                                    
                  Please respond to                                                                 
               oracle-l_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_at_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_at_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

Received on Wed Jul 07 2004 - 12:49:14 CDT