what is global_name is set to??
Raj
--- Mike Hennesy <orcl9ps8dba_at_yahoo.com> 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_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
> -----------------------------------------------------------------
>
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_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
-----------------------------------------------------------------
Received on Wed Jul 07 2004 - 13:01:19 CDT
