Home » RDBMS Server » Networking and Gateways » how to drop a database link?
how to drop a database link? [message #66913] Wed, 12 March 2003 10:20 Go to next message
Bushan
Messages: 11
Registered: February 2003
Junior Member
Hi I am using the following to drop a database link,
DROP DATABASE LINK dblink_name;

But Oracle says
ORA-02024: database link not found

If I want to see a list of all database links what table should I query?
Please help?

Report message to a moderator

Re: how to drop a database link? [message #66917 is a reply to message #66913] Wed, 12 March 2003 11:34 Go to previous messageGo to next message
Bushan
Messages: 11
Registered: February 2003
Junior Member
I found the answer, don't bother to answer.

Report message to a moderator

Re: how to drop a database link? [message #67217 is a reply to message #66913] Sat, 14 February 2004 03:20 Go to previous message
Nitin Arora
Messages: 7
Registered: February 2004
Junior Member
Hi there,

U can connect to system and query on table "all_db_links". This table will give u details of all database links in the database. Also u need to specify word PUBLIC in the syntax of dropping the link in case u are not the owner and the link is a public link.

U can drop the link by following command

drop public database link <db_link name>;

Regards

Nitin

Report message to a moderator

Previous Topic: Oracle OLEDB provider tnsname connection error
Next Topic: Oracle Server Renames
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 28 04:03:29 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.