Re: Link problems

If you create a PUBLIC dbl, you must drop a PUBLIC dbl.

    DROP PUBLIC DATABASE LINK link1;

And obviously you must have the DROP PUBLIC DATABASE LINK priv (probably you have it if you have the CREATE PUBLIC DATABASE LINK priv)

I hope that helps

--
Ciao

Eugenio
remove _nospam from reply address

Opinions are mine and do not necessarily reflect those of my company

=======================================================
kal121_at_my-deja.com wrote in message <8kliqo$8g4$1_at_nnrp1.deja.com>...


>I'm experiencing two problems:

>

>I can't drop a link that I created. This is how I created the link:

>

>CREATE PUBLIC DATABASE LINK link1

>CONNECT TO user1 IDENTIFIED BY secret

>USING 'godzilla';

>

>When I try to drop it (as myself, the link creator) I get:

>

>SQL> drop database link link1;

>drop database link link1

>                   *

>ERROR at line 1:

>ORA-02024: database link not found

>

>The link belongs to "PUBLIC", is this the problem?

>

>**********************************************************

>

>Second problem:

>

>When I actually try to use the link, I get the following error:

>

>SQL> select * from table1_at_link1;

>select * from table1_at_link1

>                      *

>ERROR at line 1:

>ORA-12545: Connect failed because target host or object does not exist

>

>Yes, the tnsnames.ora file is set up with the correct service name and

>the instance and listener is up on the maching I am "linking to".

>

>So what's the problem here? I successfully "linked up" two other Oracle

>databases this morning, no problem! But this one just doesn't work.

>

>Thanx

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.