Re: Database Links and Weird Behavior

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 19 Oct 2007 19:15:10 +0200
Message-ID: <ffated$bmv$1@news4.zwoll1.ov.home.nl>

martin.chip_at_gmail.com wrote:
>
> DEVA
> create database link ORAAPPS.US.ORACLE.COM
>
> DEVB
> create database link ORAAPPS.US.ORACLE.COM
>
> DEVC
> create database link ORAAPPS.US.ORACLE.COM

Which db link, did you say? A, A or ... A?

Set global_names to true - it forces you to use sensible names for db links.

Synonyms, anywhere - public, perhaps?
Procedures pointing to objects in other schemas? And please patch your 9i to something supported, like 9.2.0.7 or better

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Fri Oct 19 2007 - 12:15:10 CDT