Re: phantom dblink
- From: Raj Jamadagni <rjamya@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 7 Jul 2004 11:04:41 -0700 (PDT)
what is global_name is set to??
Raj
--- Mike Hennesy <orcl9ps8dba@xxxxxxxxx> wrote:
> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
=====
Best Regards
Raj
---------------------------------------------------------
select mandatory_disclaimer from company_requirements;
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
