phantom dblink 2004-07-07 - By Ruth Gramolini
I forgot to include the part about the global_names. If you set it to
false, the problem will go away also.
-- --Original Message-- --
From: Ruth Gramolini [mailto:rgramolini@(protected)]
Sent: Wednesday, July 07, 2004 2:13 PM
To: oracle-l@(protected)
Subject: RE: phantom dblink
If one DB is a clone of another then you have to change the DBID in order
for the two DB 's to appear separate. Use the DBNEWID utility to change the
name and DBID or just the DBID. We had a similar problem with DB links and
solved it in this way.
HTH,
Ruth
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Mike Hennesy
Sent: Wednesday, July 07, 2004 1:47 PM
To: oracle-l@(protected)
Subject: phantom dblink
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
