Re: Database link cannot be dropped

Thank you all for help. My SQLNET.ORA has followings only:   NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)   SQLNET.EXPIRE_TIME= 10 Output from DBA_DB_LINKS is below:
OWNER DB_LINK USERNAME HOST CREATED

------------------------ -------- ------- -------------------
USER1 TESTDB5.DOMAIN.COM USER1    testdb5 15-06-2006 10:58:02
USER1 TESTDB5            USER1    testdb5 25-05-2006 21:37:32
USER2 DBLINK1.DOMAIN.COM USER3    devdb1  15-06-2006 11:06:25
USER2 DBLINK1            USER3    proddb1 20-02-2002 09:05:39

On 13 Jul 2006 06:54:23 -0700, "Mark D Powell" <Mark.Powell_at_eds.com> wrote:

>
>gazzag 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.
>>
>> 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
>>
>
>Forte, the DDL you posted would drop a private database link owned by
>the connected Oracle username. Who does the link you are trying to
>drop belong to? The query gazzag posted will provide the necessary
>information.
>
>drop public database link xxx.whatever;
>
>HTH -- Mark D Powell --
Received on Wed Jul 19 2006 - 15:13:49 CDT