Home » RDBMS Server » Networking and Gateways » db link problem
db link problem [message #66915] Wed, 12 March 2003 11:24 Go to next message
Bushan
Messages: 11
Registered: February 2003
Junior Member
This is weired , I did the following query and got the names of the db links,

select substr(db_link,1,30) from dba_db_links;

SUBSTR(DB_LINK,1,30)
------------------------------
DB29.WORLD
DBLINK29.WORLD
HNPIS29_TCP_WG8.WORLD
REMOTE_CONNECT.WORLD
REMOTE_CONNECT2.WORLD
WG8.EHDL
WG8.WORLD

But when I try to drop them using
drop database link WG8.WORLD;

I am getting the following
drop database link WG8.WORLD
*
ERROR at line 1:
ORA-02024: database link not found

I created these links. How can I drop these links?

Report message to a moderator

Re: db link problem [message #66916 is a reply to message #66915] Wed, 12 March 2003 11:33 Go to previous messageGo to next message
Bushan
Messages: 11
Registered: February 2003
Junior Member
Don't bother, I figured out the answer.

Report message to a moderator

Re: db link problem [message #66941 is a reply to message #66915] Thu, 20 March 2003 05:12 Go to previous message
Velu Natararaj
Messages: 12
Registered: March 2003
Junior Member
connect as sysdba, and delete the link which ever you want to delete from the table link$.

Velu Natarajan

Report message to a moderator

Previous Topic: dynamic service registration with nondefault listener
Next Topic: Aoto Start Database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 11:47:39 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.