Raj
--- Mike Hennesy <orcl9ps8dba@(protected) > 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@(protected) ;
>
> returns rows. I would expect a ORA-02019 (See ORA-02019.ora-code.com) 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@(protected)
> 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
