Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Database link cannot be dropped

Re: Database link cannot be dropped

From: gazzag <gareth_at_jamms.org>
Date: 13 Jul 2006 02:45:02 -0700
Message-ID: <1152783902.608055.314550@m73g2000cwd.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.

What do you get from the following query?

SELECT * FROM DBA_DB_LINKS; Additionally, post your sqlnet.ora file so we can see that.

HTH -g Received on Thu Jul 13 2006 - 04:45:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US