Re: Database link cannot be dropped

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Thu, 20 Jul 2006 22:19:12 GMT
Message-ID: <J2q3C4.2Hx@igsrsparc2.er.usgs.gov>

Anurag Varma wrote:
> 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
>

It may be worth a try, but did you enclose the link name in double quotes?

DROP DATABASE LINK "XXX"; It might not work, but it's worth a shot...

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Thu Jul 20 2006 - 17:19:12 CDT