Oracle Database Discussions

Hi

I am trying to drop an db link and it says that the dblink does not exist .

Here is the db link info

select OWNER,DB_LINK from dba_db_links;

OWNER DB_LINK
------------------------------ ----------------------------------------
SMART_DEPLOY RCD_D.CONTACT.CO.IN
SMART_DEPLOY RCD.CONTACT.CO.IN

Now i try to give the command


drop public database link RCD_D.CONTACT.CO.IN;

ERROR at line 1:
ORA-02024: database link not found

Any update on this is highly apprciated .

Thanks

Edited by: 790072 on 20/02/2012 13:30