Re: Database link cannot be dropped

From: Anurag Varma <avoracle_at_gmail.com>
Date: 20 Jul 2006 14:29:25 -0700
Message-ID: <1153430965.079542.81960@p79g2000cwp.googlegroups.com>

Forte Agent wrote:
> Dumb question . . . . .
>
> I have an Oracle database 10.2.0.2 where I cannot drop database links.
> When I do "drop database link XXX", database link named
> "XXX.domainname.com" is dropped, but not "XXX". What should I do?
> Thank you in advance.

You might have global_names = true and have a domain specified.

You might need to set global_names to false to accomplish what you are doing (However, understand the replication repurcussions of doing that).

Anurag Received on Thu Jul 20 2006 - 16:29:25 CDT